Shareware Overload Trio 2/Shareware Overload Trio Volume 2 (Chestnut CD-ROM).ISO/dir42/bbdo43.zip/DOALL.DOC

Text File | 1994-04-06 | 141KB | 3,109 lines

     April 6, 1994
     =================================================================
                                   DOALL
     =================================================================

                                User's Guide
         Most questions can be answered by reading this User's Guide


                         COPYRIGHT  1994  B&B Systems
                                 B&B SYSTEMS
                          P.O. Box 171  627 Madison
                           Waukesha, Wisconsin 53187
     Voice:414-544-5988 (9:00-5:00 CDT)  Data/Fax [phone] (24hrs)
                 Data line is P.C. Manager, B&B system's
             Bulletin Board for Files+Tips+Support+On-Line Ordering
                              Compuserve:70265,410


     LIMITED SHAREWARE VERSIONS OF THIS SOFTWARE ARE DISTRIBUTED
     FREELY.  NO PRICE OR CONSIDERATION SHOULD BE CHARGED FOR THIS
     SOFTWARE, UNLESS IT IS FOR THE COST OF REGISTRATION WITH B&B
     SYSTEMS.  COMMERCIAL DISTRIBUTORS MAY DISTRIBUTE THIS SOFTWARE,
     BUT THEY SHOULD NOT CHARGE FOR THIS SOFTWARE, ALTHOUGH THEY
     COMMONLY COVER THEIR COSTS WITH A "DISTRIBUTION" FEE. FILES AND
     PROGRAMS ON THIS DISK SHOULD NOT BE MODIFIED, NOR SOLD AS PART OF
     SOME OTHER INCLUSIVE SOFTWARE PACKAGE.  REMEMBER, DEMO VERSIONS
     LIMIT THE NUMBER OF RECORDS YOU CAN ADD.






























     B&B DOALL User's Guide                                          2

     BBDO.ZIP CONTAINS THE FOXPRO RUNTIME FILES.  IF YOU ALREADY HAVE
     THEM, BBDOS.ZIP IS SMALLER.

     *------------------- What is DOALL ??? -------------------------*
     |                                                               |
     |      The Front End for any dBase/FoxPro/Alpha4/Compatible     |
     |         data base - The complete easy-to-use system           |
     |   for MAILINGS, TELEMARKETING, SALES LEADS, OFFICE RECORDS,   |
     |   LETTERS, REPORTS, LABELS, CONTACTS, CUSTOMERS, ETC.         |
     *---------------------------------------------------------------*

     * FASTER - Uses SQL technology for counting records, producing
     labels and reports.  Produces reports on 40,000 record file in
     less than a minute.  ADVANTAGE? You don't have to use SQL
     commands, SQL is called automatically using regular menu
     selections!
     * Full Adding/Editing
     * Produce reports/labels/letters in any sort/for any records
     * A data converter. Import spreadsheets/Word Processors,
       change data
     * Displays memo field/notes while browsing thru individual
       records.
     * Search any field, value within field - Replace with any new
       value.
     * Search memo type fields
     * Change color schemes
     * Use the SAME engine for accessing files
       (Minimizes learning time)
     * Move records from one system, find Duplicates and move
       back again
     * Change capitalization, replace one field with another value
     * Control printer functions for all printers
     * Add, Change, or Delete any fields yourself
     * Modify "help" files
     * Make custom screens for data validation when adding records.
     * When adding records, have any data repeated
     * Make "Lookup" files for any/all fields in the data file
     * Automatically calls your own custom.prg program
     * Put US Postal Service barcodes on labels
     * Use "Lookup" <F2> function in any field in Browse screen,
       say for ZIP CODES. If <Enter>, information from all "like"
       fields in the ZIP "Lookup" file will be transferred to main
       data file.
     * All indexes are updated continuously, thus, if you commonly
       use a custom sort, it will not have to be recreated each
       time you use your system.
     * Browse screen allows users with modems to dial phone numbers,
       then enter your notes about the phone call
       - automatically enter date, topic, update callback date.
     * Create multiple labels of one record.  Ability to "nest"
       letters within other letters.
     * If you have FoxPro, you can create/modify/run faster SQL-
       Query by Example reports, labels and browses
     * Capability to add custom EDIT SCREENS and ADD SCREENS
     * If CALLBACK date field exists, pending callbacks will pop up
     * When producing letters:
     B&B DOALL User's Guide                                          3

       - Automatic update of action codes and dates when producing
       letters if field named ACTION1, ACTDATE1, ACTION2, ACTDATE2
       exist (name of letter/date is inserted into ACTION1/ACTDATE1),
       other values moved
       - Letters requiring special attention - use a field called
       "BELLRINGER" to pause the printer and ring the bell, eg.
       insert "ADD CATALOG"
       - Reports allow printing of follow-up lists to Sales Reps/Local
       Offices and/or Distributors.
     * Support data exchanges TO/FROM REMOTE OFFICES (field personnel
       - sales reps) and CENTRAL OFFICE for overnight upload/download.

     * Get record COUNTS for selected records
     * Partition Browse screen so you can still see the NAME or
       COMPANY on the left side of the screen while moving around to
       other data.

     DOALL will give you comprehensive access to your Dbaseiii,
     Dbaseiv, FoxBase, FoxPro, AlphaFour or compatible file WITHOUT
     HAVING TO WORRY ABOUT FORMATS, SETUPS, LEARNING A NEW SYSTEM EACH
     TIME YOU WANT TO USE A DATA FILE. (Note: FoxPro2.0 data files
     have unique MEMO fields compared to dBase).
     ====================
     DISTRIBUTION  POLICY
     ====================
     DEMO versions of Systems produced by B&B Systems of Waukesha are
     commonly distributed through the 'Shareware' concept.

     SHAREWARE Software means that you can try software prior to
     purchasing it.  It is based on the premise that 1) you should be
     able to try software before you purchase it,  2) sharing of
     information is to be encouraged, and 3) those users who decide to
     use such software have an obligation to support the Shareware
     authors so that Shareware development can continue.

     Shareware versions of this software have limitations, usually
     number of records or time period, and are distributed freely.  We
     encourage others to distribute these demo versions.  Should you
     decide to purchase, you can ONLY PURCHASE through B&B systems.
     Some companies will charge you for a disk copying service, but
     they are NOT ALLOWED TO SELL B&B SYSTEMS.  They are basically a
     "disk copying service".  Files and programs on this disk should
     not be modified, nor sold as part of some other software package.


     If you decide to use this software, please register.  It is the
     only way QUALITY software will continue to be available.

     ==============================================
     WE ENCOURAGE YOU TO DISTRIBUTE SHAREWARE DEMOS
     ==============================================
     Although B&B Systems encourages you to copy and distribute
     limited edition Demo versions, this is not public domain
     software.  This program is copyrighted.  Also, should you decide
     to register your system, remember that sharing registered copies
     with others is not just illegal, but registrations from all users
     B&B DOALL User's Guide                                          4

     will help ensure that YOUR system continues to IMPROVE and GROW.
     INSTALLATION
     ============
     If you haven't made a BACKUP copy recently, do it now.

     1) If you don't already have one, Make a "DOALL" directory: At
     C:\>, enter MD DOALL, then CD\DOALL (or use the INSTALL.BAT file
     included)

     2) Copy BBDO.EXE to the DOALL directory, C:\DOALL>COPY A:*.*

     3) Enter BBDO,  and the individual files will be extracted, and
     you will be asked some setup questions that are stored in the
     file config.mem.

     4) See Network section for setting up workstations.  Setup your
     file server first.  Also, for Peer to Peer networks like
     Lantastic, Net Lite, you may need to assign "read only"
     attributes to the "executable" type files at the DOS level.

     5) Startup Syntax: DOALL <name of .DBF file>
     To start your system, enter DOALL to answer set-up questions, and
     get to main menu.  Or, you can start your system to automatically
     use a file by entering DOALL <dbffilename>.   (dbffilename) is
     the file name of any Dbase/FoxPro/Clipper/Alpha Four file.

     Upon startup, DOALL will create a compound index file
     automatically, allowing you to select any sort quickly.  This may
     take some time, depending on the size of your data file.  Note:
     you can turn off the automatic creation of the .cdx file with the
     Environmental Variable SET CDX=OFF discussed later.


     TIP: If you have three major files that you commonly access, you
     can put the following entries into your "menu" to automatically
     call the right file:
     Menu Description: CUSTOMER FILE     Command: DOALL customer
     Menu Description: VENDOR FILE       Command: DOALL vendor
     Menu Description: VEHICLE FILE      Command: DOALL vehicle

     Any errors will create a file called error.txt.  B&B Systems can
     use this file to resolve problems.

     WINDOWS TIP: You can automatically open the same data file each
     time you run DOALL by editing DOALL's "properties".  Select the
     FILE menu in the Program Manager and select the "properties"
     option.  This will allow you to edit the Windows command line.
     On that line, after C:\DOALL, enter the name of your file, ie,
     D:\WORK\WORKFILE.DBF.


     CAUTION-1: DON'T ACCESS multiple .DBF files that start with the
     same 1st 4 characters. (rename some of your .DBF files)  The
     reason is that many DOALL support files are created named:
     ????.MEM and if you have two files called, say, MASTER1.DBF and
     MASTER2.DBF, the sort file MASTSORT.MEM file will be used as the
     B&B DOALL User's Guide                                          5

     sort definitions for BOTH files.

     CAUTION-2: You will get an error at startup if you try opening a
     .dbf file with a name beginning with a number.  Just rename the
     desired file with at least one character at the beginning.

     DOS ENVIRONMENTAL VARIABLES
     ===========================
     You can control some attributes of DOALL by setting some DOS
     values in your autoexec.bat.  Insert a line like: SET CDX=OFF,
     and if the value of CDX is checked it will be equal to OFF.

     You can control whether the master .CDX (index) file is created
     when missing.  This is not recommended unless you have a specific
     reason for it: SET CDX=OFF.


     INSTALLING SEPARATE B&B NETWORK FILES ON WORKSTATIONS/SERVER
     (allows each workstation to have different screen setups, etc.)
     ===============================================================
     You can install your B&B System on the file server and have all
     workstations access your program files from the server.
     BUT IF YOU ONLY HAVE ONE CONFIG.FP and FOXUSER.DBF FILE AND THEY
     ARE ON YOUR SERVER, THE FOXUSER.DBF AND FOXUSER.FPT NEED TO BE
     MADE "READ-ONLY" IN ORDER TO BE SHAREABLE.  AND IF THEY ARE
     "READ-ONLY", YOU CAN'T SAVE CHANGES TO YOUR browse screen, like
     split screens, field order, display length.



     To use the network option that installs individual setup files
     for you, install the system and run it on the network drive, say
     F:.  Upon first time use, you will be asked if you wish the
     network setup.  Then run your networked system from the
     workstation(s) and select Network setup from the setup menu. This
     is what you will accomplish each time:
     ------------------------------------------------------------
     1.Define a location for each machine's separate CONFIG.FP file.
     2.Define a location for each machine's separate FOXUSER.DBF/FPT
     3.Define locations for various "working" directories.

     After these values are filled-in, the system will:
     --------------------------------------------------
     1. Change EACH machine's autoexec.bat so that the location of
     EACH MACHINE'S CONFIG.FP file is identified with the line:
     SET FOXPROCFG= <C:DIRECTORY>\CONFIG.FP
     2. Copy the file CONFIG.DEF to <new location>\CONFIG.FP
     3. Write the "working" directory names for EDITWORK, SORTWORK,
     OVERLAY, RESOURCE and PROGWORK onto the tail end of the new
     CONFIG.FP file.
     4. Copies the files DEFUSER.DBF/FPT to <new location>\FOXUSER
     (if any of these steps are not accomplished properly, you can
     copy these files manually and/or edit config.fp)

     This means that when you re-boot after installation, the SET
     FOXPROCFG= variable will point to the location of the CONFIG.FP,
     B&B DOALL User's Guide                                          6

     and the CONFIG.FP will point to the FOXUSER resource file, and
     all of the temporary work directories.  WARNING: If you ever
     delete directories that are referenced in config.fp, your system
     may not load - CANNOT CREATE PROGRAM FILES.  So that you don't
     inadvertently delete a directory, you could pick the same
     directory for the workstation files and the temporary work
     directories so that there is at least one file in the directory
     to avoid removal (ie. C:\DOALL>).

     The CONFIG.FP file is a FoxPro command file that contains startup
     values specific for each workstation.  Unless you are familiar
     with these commands, or have specific needs to customize, you can
     leave the default .FP file alone.  The FOXUSER file stores
     settings, browse window definitions, etc.



     NETWORK - GENERAL
     =================
     On peer to peer networks (ie. Lantastic, Novell Lite), you may
     need to use DOS's ATTRIB command to assign the read-only
     attribute to 1) the FOXUSER.* files plus 2) any "executable" type
     files on your server.  These are any .EXE files, FOXPRO.ESO,
     FOXPRO.ESL, .COM, .FXP and .SPX files.

     Example: C:\DOS\ATTRIB +R FOXPRO.ESO

     Also, if you intend to use the F2 Lookup file features and you DO
     NOT Intend to Edit the lookup file often, you can assign read
     only attributes to the <lookupfile>.dbf and .cdx files to speed
     up access to these files.

     Also, if you load the operating system SHARE program, make sure
     that the values for space reserved for file locking and the
     designation for the amount of files that can be locked at one
     time are sufficient, such as: SHARE /F:5120 /L:500.

     Network versions of B&B Systems work on any LAN that supports
     standard protocols of DOS versions 3.1 and greater (ie. Interrupt
     21 data locking).  B&B Systems are NetBios compatible, and will
     support any number of workstations.   Networks supported: NOVELL;
     3COM; 3+; 10NET(v 4.0); PC-NET; PC-LAN; LANTASTIC; BANYAN;
     INVISIBLE; SIMPLENET(v 3.0).



     MEMORY ISSUES
     =============
     If using DOS5.0's  DEVICE=EMM386.EXE in your config.sys, and
     NOEMS appears in the command line, try your system without this
     command.  NOEMS says " no expanded memory" and turns off the
     demand pager.  You can also try to specifically allocate a
     portion of the memory as expanded by including the command RAM
     and the number of kilobytes of Expanded Memory, such as
     DEVICE=EMM386.EXE RAM 3072).  YOU SHOULD HAVE A MINIMUM OF 2M of
     EMS, and at least 2 Megabytes of hard drive storage.
     B&B DOALL User's Guide                                          7

     1. REGULAR EXPANDED MEMORY VERSION - B&B Systems are normally
     distributed using the Standard FoxPro which does NOT USE Extended
     Memory.  Make as much Expanded Memory available as possible.  To
     make Extended Memory act like Expanded, use a memory manager that
     provides the standard LIM4.0 interface.  If you have an older
     memory manager, and your system behaves strangely, add EMS64=OFF
     to your config.fp file to avoiding using the first 64K of
     expanded.

     If using QEMM, 386MAX, or DOS5.0's EMM386, make sure these
     managers define memory as Expanded.


     2. EXTENDED MEMORY VERSION - If you have enough extended memory
     (at least 2m, 1.5m free), a 386 or greater machine, and would
     like more performance, ask us for the Extended version of your
     B&B system.)

     If you get an error regarding "Cannot locate desired version ..."
     for Regular version it means you need more Expanded memory.
     Eliminate NOEMS statement in EMM386 line.  For Extended version,
     you need more Extended Memory.

     RUNTIME FILES
     =============
     B&B Systems normally come with the standard (expanded) FoxPro
     runtime files.  Files for DOS are called FOXPRO.ESO and
     FOXPRO.ESL (For WINDOWS, the runtime file is FOXW2500.ESL).
     Runtime files are simply the basic/low-level files that supplies
     all of the basic FoxPro functions, while the .EXE file is the
     custom system that uses these files.

     These "runtime" files are free and available on B&B's Bulletin
     Board (see data number above if you have a modem and would like
     to download these files).  If you want to use the Extended
     runtime file, YOU ALSO NEED TO GET the Extended version of your
     B&B System .EXE file from B&B Systems in order for your system to
     take full advantage of Extended memory.

     When FoxPro supports Unix and MacIntosh, B&B will also support
     it, allowing portability between operating systems.


     REQUIRED EQUIPMENT for WINDOWS
     ==============================
     - 80386SX or greater processor
     - Mouse
     - 6MB RAM
     - MS-DOS 3.1 or greater
     - Windows 3.1 running in 386 enhanced mode
     - If network, network software that supports a NETBIOS.

     WINDOWS TIP: If you run your B&B Systems under windows and your
     data entry boxes are white on a white background, and you'd like
     to see the data entry boxes in a different color, chose Control
     Panel to access your Windows COLOR options.  We have found
     B&B DOALL User's Guide                                          8

     selecting the color set:EMERALD CITY gives nice screen colors.


     WINDOWS TIP: Since the DOS version of all B&B Systems are mouse
     compatible, you can easily use the DOS versions in the Window
     environment.  To make your B&B application selectable from
     Windows and add an icon, just select FILE/NEW from the Program
     Manager, and add a new item with a NAME for the application, the
     Command that the runs it (ie. DOALL, CNG, etc.), and the
     directory it resides in (ie. C:\DOALL, D:\CNG, etc.).   Remember,
     if you get unpredictable results, you could be running short of
     memory.  Try running outside of windows.  If you get different
     results, you don't have enough memory left with windows resident
     in memory.  If you know how to use .PIF files, you can define
     custom memory requirements for your B&B system.


     CONFIG.SYS FILE
     ===============
     Your system's config.sys file will be checked for the recommended
     line: FILES=99.  If the value is less, you will be warned to
     change this value.  For Novell Networks, insure that
     FILEHANDLES=99 in the NET.CFG or SHELL.CFG.



     IF YOU HAVE FOXPRO
     ==================
     If you have FoxPro, you can operate your B&B System several
     different ways, depending on whether you wish to take advantage
     of some FoxPro features, not available in the standalone B&B
     System.

     Options:
     1. Standalone - Start your B&B System normally, by entering your
     <B&B System name> at the DOS prompt (or, in Windows clicking on
     the icon).  Your system will operate using the FoxPro runtime
     files:FOXR.EXE, FOXPROL.ESO, FOXPROL.ESL.

     2. Run Within FoxPro - Start your system within FoxPro by issuing
     FOXPRO <B&B system name>.  (Note: substitute FOXPROL if you have
     the LAN/Network version, or in Windows, run FoxPro and when the
     command window is displayed, enter DO <B&B System name>).  Please
     be sure that the B&B system you have is the same as the FoxPro
     version.  For example, your B&B System should be the DOS version
     if you have FOXPRO for DOS.

     Option 2 provides access to SQL menus, and handles some functions
     automatically for you.  Some B&B Systems will ask that you
     compile a .PRG file (to make an .FXP file).  This is no longer
     applicable because .PRGs will be compiled for you.  An example of
     this process is when you are using a data base file and adding a
     record for the first time in B&B's DOALL.  A window will inform
     you that an "add screen" file, called <data file name>.PRG has
     been newly created and in order to use the extra features that
     you can insert in this file such as: data validation or file
     B&B DOALL User's Guide                                          9

     lookups (see sample.prg for an example), you need to compile it.
     Well, you can edit this .prg file to add those features, similar
     to the sample.prg file, and FoxPro will compile it for you the
     next time it is called.


     DEMO
     ====
     If you are using a DEMO version, you will see a registration
     reminder.  The Demo is only good for a limited period of time.
     You have 365 days upon first installing demos to determine if it
     will do the job for you.


     CREATING A NEW FILE
     ===================
     If you enter DOALL <filename> and <filename> is a non-existent
     file, you will have the option of creating that file.  Remember
     that when you create a file you will be defining each field
     within that file by assigning a name, type (character, numeric,
     date, memo, logical) and length.  Commonly you should use
     "character" type fields, even if the fields commonly contain
     numbers such as zip codes.  You normally would use numeric type
     fields for fields that may require "totalling".  Date type fields
     provides the proper format for dates (When SET CENTURY=OFF in the
     config.fp file, the year is shown as "93" not "1993").  Memo type
     fields allow unlimited text to be stored in them and they can be
     edited by pressing CTRL-PgDn when the cursor is on that field.
     Logical fields allow only True/False or Yes/No entries (T/F,
     Y/N).

     When you create new data base files, a .DBF is created, as well
     as an index file .CDX, and an .FPT file if a MEMO field is used.
     (a .TBK file is a backup/prior version of an .FPT file).

     GENERAL
     =======
     To help in navigating through this system, remember these simple
     rules: A mouse is helpful to pick options, such as menu options.
     From the keyboard, use the <ALT> key, then cursor, to pick menu
     options from the top menu.  <TAB> is useful to go from option to
     option.  If you get stuck, <CTRL-W> commonly SAVES work, and
     <CTRL>-Q ABANDONS work, <ESC> works similar to CTRL-Q and works
     well in menus.

     To help understand the system, let's start by doing what you'll
     be doing most - looking at records.  Selecting Browse/Edit from
     the main menu.  As you get used to the system, you will normally
     just <Enter> twice to select the default for the next two
     options, SORT and SELECT.  This is a quick way to look at your
     records.  But, there will be times when you will want a
     particular sort, say last name, or to select particular records,
     such as last name='SMITH'.  Just use the cursor keys to pick the
     SORT and SELECTION you want.

     WHICH SORT ?? (FLEXI-SORT)
     B&B DOALL User's Guide                                         10

     ==========================
     When you first use your system, like browsing records, you'll
     notice that there will be a screen asking for your desired sort.
     Each of the fields from your data base will be shown.  If you
     have a field called COMPANY, you will automatically be able to
     select the COMPANY sort WITHOUT having define it or wait to have
     an index prepared.

     Technical Note: The first time you use your system, an index or
     sort file will be created if none is found.  A sort for each
     field in your file is prepared and combined into one SORT file
     with the same name as your data base file, but with a .CDX
     extension.  All of the sort definitions are maintained in the
     .CDX file and are kept current when you add/delete/change
     records.   If you do not use some of your sort options, and you
     delete them, you can reinstate the .CDX file to its original
     state (a sort for all fields) by deleting your main .CDX file.
     If your main file is customer.dbf, delete customer.cdx.

     Example: selecting three fields STATE+ZIP+LASTNAME will produce a
     sort Last Name sorted WITHIN Zip Code sorted WITHIN State - Major
     to Minor Sort order.

     Note that FoxPro compound indexes (.CDX), do not consider
     CAPITALIZATION.  The AA's and BB's will be together in one group
     and the aa's and bb's will be in a separate group.  Whenever you
     add - <INS>ert more sort definitions, the fields are
     automatically surrounded by UPPER(<fieldname>).  UPPER simply
     converts values to uppercase, so that all A's are together and
     all B's together regardless of capitalization. You can also
     <E>dit your sort definition any way you want.

     WHICH RECORDS ??   FLEXI-SELECT
     ===============================
     The "SELECT ALL RECORDS" is always the #1 selection. You can add
     <INS>, delete, <DEL>, or <E>dit your selections.   Flexi-Select
     allows you to see specific records in your Browse Screens, or
     Reports, or Labels.

     When adding a Flexi-Select option you will be asked to select a
     FIELD (If you just want to see certain last names, you'd select
     LASTNAME).  After you've selected the field, you'll select an
     OPERATOR.  An example of an operator is: 'equal to' or 'greater
     than'.   Next, you will be asked to enter a value to be tested
     for (eg. Last Name='SMITH').

     Finally, you will select QUIT, or select a CONNECTOR to link
     additional selections, like below:

         Examples: Last Name='SMITH'
                   Last Name='SMITH' .OR. Last Name='JONE'
                   Last Name='SMITH' .AND. Zip<>'666', etc.

     Note that B&B will automatically insert the word "UPPER()" around
     your sort definitions.  This allows you to see all records
     whether they are entered into your data file as SMITH or Smith.
     B&B DOALL User's Guide                                         11

     You can eliminate UPPER() if you need to by using the <E> to
     edit.

     The <E>dit feature in Flexi-Select allows you to be more precise
     in the selection of your records.  The reason for this is that
     the use of parentheses allows better Boolean logic.  B&B will not
     automatically insert these parentheses because it really can't
     determine the placement of parentheses in a multitude of .AND. or
     .OR. statements.  For example, the following two expressions will
     select different records simply because of careful placement of
     parentheses.  This is BOOLEAN logic and it basically goes like
     this: Line #1 (below) will select all records having a Last name
     equaling 'SMITH' and not having a zip code starting with '666'.
     After that test has BEEN MET, other records whose Last name may
     NOT be 'SMITH' will be selected as long as the zip is not equal
     to '555'.  Line #2 will select just the records having a Last
     name equaling 'SMITH', and once that test has BEEN MET, THAT
     record cannot have a zip code of '555' or '666'.

            Last Name='SMITH' .AND. Zip<>'666' .OR. Zip<>'555'
            Last Name='SMITH' .AND. (Zip<>'666' .OR. Zip<>'555')

     If you are familiar with FoxPro commands, you can also use the
     edit function to customize your own selections such as DELETED()
     which selects only records that are marked for deletion.

     SPEED TIP: Instead of using Flexi-Select to look at the records
     with a lastname of "Smith", use Flexi-Sort and pick the lastname
     sort.  Then, when in the browse screen, use the Find Record top
     menu option to find "Smith".  This is faster.

     Once in the Browse screen, you will see options at the top of the
     screen.  One of them is "Browse".  Highlighting and <Entering> on
     this option will give you an ability to add, and mark records for
     deletion.


     FIND RECORDS
     ------------
     Other options are "Find Records" which will allow you to search
     for a record based on a value in any field.  In addition to
     searching for values in any field, you can look for addresses
     that BEGIN with "123" OR have "123" ANYWHERE in the address
     field.

     SEARCH/REPLACE
     --------------
     Another option, "Search and Replace", is very powerful.  It
     should only be used after making sure you have a backup file, and
     you have used Flexi-Select to pick the appropriate records first.
     After selecting this option, you can say, replace all Last Names
     with 1)BLANKS by entering 1's in the replace value, with
     2)"SMITH" by entering "SMITH" in the replace value, or 3)Proper
     capitalization by entering the word "PROPER" in the replace
     value, or a 4)VALUE FROM ANOTHER FIELD by selecting the other
     field for the replace value.
     B&B DOALL User's Guide                                         12

     In regards to #4 above, you can replace one type of field
     (Character) with the value in another type of field (Numeric),
     but be cautious. Make a backup copy first.  Not all values are
     replaced accurately, especially if some character fields contain
     both numeric and non-numeric characters.

     TIP: Remember that prior to entering the Browse screen you will
     select a SORT.  If you are "replacing" values in THE SAME FIELD
     AS THE SORT FIELD, you will get unpredictable results. Use a
     different sort if this is the case.  For example if you wanted to
     replace all of the EMPTY Company names with ACME, the first empty
     record will become ACME, and it will suddenly be at the bottom of
     the file (and finished with replacing) because it is sorted by
     Company name.


     HELP FILE
     =========
     The Help menu option will access the helpfile.dbf and is
     modifiable by the user for customization.

     If you are in your file and would like to be able to access a
     "popup" or "lookup" file of say Zip Codes when you are in the ZIP
     field, OR valid codes when you are in your field called CODE,
     just press <F2>. If a file called ZIP.DBF or CODE.DBF exists, it
     will "popup" for you to access.

     NOTE: if you don't have any popup data files, you can create your
     own by entering DOALL ZIP, or DOALL CODE.  You will then have the
     option of creating these files.



     LOOKUP FILES - BROWSE SCREENS
     =============================
     A Browse Screen looks like a spreadsheet with rows and columns.
     Records are displayed horizontally in rows and each field is
     listed vertically in columns.  Occasionally, only one record will
     appear to be displayed on a page, this is the "CHANGE" mode.  If
     you use your <ALT> key to highlight the BROWSE option at the top,
     you'll see that you can toggle between the BROWSE/Grid mode and
     the CHANGE/individual record display.  When in the Browse mode,
     entering <F2> will access other data bases for additional
     information.  When your cursor is on a field, you can press <F2>
     to access a lookup .dbf file.  The lookup file name must have the
     same first 8 characters as the field name.  For example, if the
     data file you are currently maintaining has a ZIP CODE field,
     pressing <F2> while your cursor is on the zip field will attempt
     to locate and display a file called zip.dbf.  If the lookup file
     does not exist, a message will tell you.  You can create new .dbf
     files to support lookup tables on each and every field.

     HOW ARE LOOKUP FILES USED?
     Lookups are used for a variety of reasons, 1. <F2> in a zip field
     will assist in reducing data entry, because you can enter the zip
     10001, then <F2> to display all zips from zip.dbf, and then
     B&B DOALL User's Guide                                         13

     <Enter> to "FILL-IN" the zip, city, state, etc. from the zip
     file.  Whenever your main data file and lookup files have the
     SAME field names, <Enter> copies information from all of the
     fields in the "Lookup" file to the main data file - a quick way
     to fill in STATE, CITY and ZIP by entering just the zip code.

     2., you can also use the lookup files for reference purposes.
     Let's say you have a file called vehicle, with a field called
     serv_code containing codes for the types of services performed.
     If you don't remember what the serv_code ALIGN means, you can
     press <F2> on the serv_code field to access a serv_cod.dbf file.
     You can then peruse the serv_cod.dbf file to see that ALIGN =
     ALIGNMENT, BRAKE2 = 2 WHEEL BRAKE JOB, BRAKE4= 4 WHEEL BRAKE JOB
     etc.   You can make your own .dbf files for lookup purposes on
     ANY field.  Hint: give your .dbf file the same name as the first
     8 characters of the field name.


     KEEP SAME FIELD NAMES IN LOOKUP ?
     ---------------------------------
     If creating a Lookup file, remember to create the new file using
     the same field names (and lengths) as your master file.  If your
     master file has ZIP 10 long, STATE 2 long (or 10 for
     international purposes) and CITY 20 long, then create the same
     fields in your lookup file.  The reason for doing this is when
     accessing your lookup file and finding the appropriate record,
     when hitting <Enter>, values in the lookup file ZIP field will be
     copied to the ZIP field in the master file, and CITY, and STATE,
     etc.   Conversely, if you have a field in both files you don't
     want changed, say "description", when you press <Enter> the data
     in the description field from the lookup file will overwrite the
     description data in the main file.


     LOOKUP FILE OPTIONS
     -------------------
     When the lookup file is displayed, you will see that some
     additional options are available.  To maintain data integrity you
     will see that the DEFAULT mode does not allow editing of the
     lookup values, but you can switch to edit mode.  You can also
     search for values, in either the first field, or second field (if
     available).  You can also perform import/export functions (for
     example, to add another state's zip codes file to the existing
     zip lookup file.  You can also Pack (remove records marked as
     deleted, or list all of the records to your printer.

     Function keys allow searches on the first or second fields.  If
     you want to find the zip code 54333, enter "5" and you will see
     the first record with a "5".  Enter a "4" and you will see the
     first "54" record.  This process can continue until a NO FIND
     occurs, in which case, the process starts over again.  Note: with
     the Zip file, if you enter a #, the file will be displayed in
     numerical order.  If you enter an alpha character (A-Z) to find
     the city, the file will be displayed in CITY order.

     If there are more fields in that file than will fit in the width
     B&B DOALL User's Guide                                         14

     of the screen, you can use the arrows or tab key to see more
     fields.

     You can also import/export data directly into, or from, your
     lookup file.



     TIP:B&B Systems makes available the latest Zip Code data for the
     USA, or in separate zip files for each state.  If you have a
     modem, you can download these files free from B&B System's
     bulletin board, P.C. Manager.  To import these files into the
     Zip.dbf file.  Simply select Import when in the lookup process
     <F2> on the zip field.  Select the file type (our zip files are
     provided in Dbase/FoxPro format) and enter the name of the file
     to be imported, such as ZIPIL.DBF.  Note: for zip files, they
     commonly contain 10 characters for the ZIP code, 2 characters for
     the STATE code, 20 characters for the CITY, and 25 characters for
     the COUNTY.  If your master file has fields with these same
     names, and if you used the lookup <F2> function in the zip field,
     while in the add mode, your B&B system will "fill-in" the zip,
     city and state names after you <Enter>.  Some companies use a 10
     character state field to accommodate international names (ie.
     CANADA).

     ADDING RECORDS
     ==============
     DUPLICATE CHECK - Prior to ADDING RECORDS     _________________________________________
     After selecting the ADD option from the menu, you will be asked
     to enter a value for one of the fields for the record you are
     adding.  The default is the first field, but you can change it by
     selecting "Setup" from the menu (<ESC> when asked to select a
     field in setup will cancel any duplicate checking).  This is a
     way of checking for duplicates prior to adding records.  If
     similar records are found, they will be displayed in a browse box
     at the bottom of the screen.  You can edit the duplicate records,
     or <ESC> to continue adding.

     CUSTOM ADD SCREEN
     =================
     NOTE: A .PRG file is made for you the first time you add a
     record.  The .PRG file name defaults to <dbf filename>.PRG.  You
     can modify this file, or make your own.  Then compile it (Using
     FoxPro which creates an .FXP file).  You can incorporate the
     lookup functions, like FILELOOK() - see below - into your custom
     screens or you can change the order of data fields.  If you don't
     compile it, a simple add screen, without special functions will
     be used.

     Edit this .PRG file (Use a word processor that treats the file as
     a DOS TEXT or ASCII file, or you can use the Edit file/Setup menu
     option). When you see the .PRG file, you'll see that information
     is displayed in the ADD screen by using the commands "@ <row>,
     <column> SAY <text>".    Data Entry boxes are displayed with the
     "@ <row>, <column> GET <m.fieldname>" command.  That's it.  Those
     two commands are all you need.  NOTE: if you are working on a
     B&B DOALL User's Guide                                         15

     normal monitor with 25 lines of text (vs. enhanced mode with up
     to 43 or 50 lines per screen - See Setup), don't modify your
     <data file name>.PRG to display something on row, say 60.

     But, there is an important extra feature that you can use if you
     would like to control data entry.  After any GET command, you can
     use a special command called "VALID <command>" to check the data
     being entered.  You can use simple validation checks such as:
     VALID(m.ZIP>'55555'.AND.m.ZIP<'66666').  OR, the control can
     access another data file for "lookup checks".  For example, the
     following two lines:

     @ 1,1 SAY 'Enter ZIP:'
     @ 1,12 GET m.ZIP VALID filelook(VARREAD(),.t.,.f.)

     does several things.  It would display the words: Enter ZIP: at
     row #1 and column #1.  It would also display a data entry box for
     the ZIP field at row #1 and column #12.  Note: the preface, m. is
     required in <dbf filename>.PRG files used when adding records, it
     is not used in <dbf filename>.FMT files used when using F10 in
     the browse screen to edit records.  There are three values within
     the parentheses after the VALID filelook command.  They do the
     following:  VARREAD() says if you have a data base file with the
     same name as the variable being read, in this case ZIP.DBF, open
     the file.  The first .t. (a true value) and determines whether to
     "SHOWLIST THE POPUP IF EXACT MATCH FOUND".  If this is true, and
     data has been entered that exactly matches one of the values in
     the zip.dbf data file, then the file will "popup" anyway.  If the
     "SHOWLIST IF EXACT MATCH FOUND" value is .f. (false), then if you
     say, enter a valid zip code, then the file will not pop-up.

     The second .f. is a SEARCH IF EMPTY indicator.  If nothing -
     blank is entered into a field, it will not check for a valid
     value.  If you want the pop-up to appear, forcing a selection
     from the pop-up file, use .t. (true).



     Repeating Data     ______________
     When adding records, you can have specific data repeatedly "fill-
     in" data into your file.  How?  Create a <dbffilename>.REP file
     (see Setup Menu) which is a one record file with the same
     structure as your regular file, and you will be asked to fill in
     the data you desire to have automatically "filled-in" every time
     you add a record.  The system will search for this file, if
     available, any values in the .REP file will be moved to the add
     screen.  (Handy for repetitive STATE, AREA CODE, CITY, etc.

     ADD Dates     _________
     In some applications, it is handy to have the "date a record was
     added", for example, I now want to print labels for records I
     entered in DECEMBER, 1992.  B&B DOALL will automatically enter an
     "Add Date" in your newly added record if you have an "ADDDATE"
     DATE field.  If you would like to add an ADDDATE field, select
     MODIFY STRUCTURE from file maintenance, and go to the bottom of
     the field list.  Add "ADDDATE", Type=DATE.
     B&B DOALL User's Guide                                         16

     Anytime you add records, the current date will be entered.  When
     you want to print labels, or a report containing just records
     added in DECEMBER, 1992, Use FLEXI-SELECT to add a selection
     "ADDDATE='  /  /  '".  Don't worry about adding a date yet
     because you will need to <E>dit this selection.  <E> to edit, and
     put "MONTH(" in front of ADDDATE, and ")=12"  after it.  If you
     also want just 1992 records, edit this line to look like:
     "MONTH(ADDDATE)=12 .AND. YEAR(ADDDATE)=1992"


     HOW DO I USE THIS <filename>.PRG FILE???     ________________________________________
     BUT, before your system can use this format file, it needs to be
     compiled (changed to a .FXP file).  If you have FoxPro you can do
     it yourself by starting FoxPro and selecting the COMPILE option
     under PROGRAM in the top menu.  Or, you can have B&B Systems
     compile it for you.  Send it to us on our BBS.  There is a small
     fee, and you can download it within 48 hours.


     CUSTOM EDIT SCREEN
     ==================
     Normally, when you edit a record, the browse screen is displayed.
     You can also have a custom edit screen.  The file required is a
     .FMT or Format file, similar to the .PRG type file discussed
     above for custom add screens.  Both type of files have @ 1,1 SAY
     'ZIP:' and @ 1,20 GET m.zip type commands.  The MAIN difference
     is that the add screen (.PRG) accesses memory variables, so the
     field zip is prefaced with an "m.", as in m.zip.  The edit (.FMT)
     screen edits the .dbf data directly, so use just @ 1,20 GET zip.

     You can even create this file by copying your <dbf filename>.PRG
     to <dbf filename>.FMT.  Get rid of any "m." notations and compile
     this file (or have B&B Systems do it for you to create a .PRX
     file).  Then, when in the browse screen, use F10 and your records
     will be displayed in full screen format, using your .FMT/.PRX
     file.

     CUSTOMIZATION
     =============
     B&B Systems are specialists in data base systems.  We offer
     customization services.

     You can add some customization yourself.  If there is a special
     option that you would like to add, B&B DOALL automatically
     searches for any file called CUSTOM.FXP every time DOALL is run.
     (an .FXP file is simply a .PRG program file that is compiled with
     FoxPro by running FOXPROL and selecting "Program", "Compile").  A
     sample custom.prg and custom.fxp file is supplied.  Look at the
     custom.prg file and you'll see that it shows how you can sense
     when a specific key is pressed and call another program.  The
     sample custom.prg file includes the sample ON KEY LABEL CTRL+F2.
     As long as the file custom.fxp is on the DOALL directory, you'll
     notice that after you start DOALL and hit <Ctrl><F2>, the product
     file will appear for your reference.


     B&B DOALL User's Guide                                         17

     You can accomplish your own customization with the line:ON KEY
     LABEL CTRL+Z DO MYJOB.  Then, make an ASCII type file called
     MYJOB.PRG with your word processor containing the appropriate
     FoxPro commands to accomplish the task you desire.  Then make a
     compiled file with FoxPro called MYJOB.FXP.  Anytime you press
     the <Ctrl-Z> keys, whatever commands you put in MYJOB will be
     executed.  Careful: avoid assigning custom jobs to key
     assignments that are used for some other purpose in DOALL.

     UPDATES
     =======
     When updates become available, registered owners are eligible for
     upgrades at one half the original cost.  And, because DOALL is
     based on FoxPro, When FoxPro versions for WINDOWS and UNIX
     appear, DOALL will also support these operating environments.

     CALLBACK FIELD
     ==============
     You may want to be automatically notified when customers require
     your attention on a future date.  If you have a "DATE" type field
     in your file called CALLBACK, every time you startup DOALL, this
     field will be checked.  If you have any records in your file with
     a CALLBACK date greater than the current date, a browse screen
     will be shown on the screen (in descending callback date
     sequence).  You can then act on these customer records.

     If you don't want to see ALL callbacks in the future, but only
     those in the next two weeks, you can define the span of days you
     want to see in the setup menu.

     LABELS & REPORTS - ALSO see SQL
     ===============================
     Some Sample Label & Report files are provided with DOALL.  You
     will NOT be able to use them AS-IS, unless the fields in your
     data base HAPPEN to be the same as those defined in the label,
     such as LastName, or Address.

     You make your own new labels or reports by selecting ADD report
     or label from their respective menus.  You can edit existing .LBX
     label and .FRX report format files from the Edit option in the
     Report/Label menus (.LBX and .FRX files are modifiable FoxPro
     Label and Report files).  Enter or Change the names of the fields
     to match your data base.  If you don't know the names of the
     fields in your data base, highlight the LABEL or REPORT menu
     option at the top of the screen, and select FIELDS.  A window
     will be provided to enter the field name into a value called expr
     (expression).  If you click your mouse on "expr", another window
     will display the field names.




     When adding new reports, you can get a quick start by clicking on
     REPORT at the top menu, then select Quick Report/Label to have
     all of the fields inserted into an empty file.

     B&B DOALL User's Guide                                         18

     IMPORTANT: when adding fields in labels, or in the Quick Report
     option in reports you will see an option to "ADD ALIAS" to the
     field name.  Click on this option to turn it off.  Do not use
     this option.  The Alias is the file name prior to the field name,
     separated by a period (.), such as myfile.lastname.  Just use
     lastname.  The reason for this is with the new, faster SQL method
     of accessing data, a duplicate of your main file is made and this
     temporary file name will not match your main file name.

     The only exceptions to using alias's are the special Rep and
     Distribu.frx reports supplied with this system.
     WHAT IF I HAVE FOXPRO?
     ======================
     REPORTS

     If you have FoxPro, and if you have the PATH COMMAND setup to
     allow access from any directory, you have more features available
     to you.  For example, if you have FoxPro and a B&B system, enter
     FOXPRO (or FOXPROL for a LAN) <B&B system name>.  You will then
     have the capability of using the SQL Reporting feature.  You can
     run predefined FoxPro LABELS/REPORTS files, or define your own
     field selections within SQL.


     To get started with SQL, try the following:  Select SQL from the
     report menu, and when prompted for the name of the existing Query
     file, <Tab> to NEW.  You can add to the selected data files in
     the top left box.  To send a simple report to a file for
     LASTNAMES equalling SMITH, Double Mouse click, or <Tab> to and
     <Enter> on the "Field Name" box in the lower section. Select
     LASTNAME from the list of fields, and enter SMITH in the
     "Example" box.

     Next, <Tab> to Output box and <Enter>.  Select "screen display"
     and "output to file".  Enter TEMP for a file name and <Tab> to
     <OK>.  Then select <<DO QUERY>> to produce your report.
     There are so many other options and features in SQL that we can't
     address them all here (See FoxPro Interface Guide), but you can
     do just about any data reporting in SQL and quickly.


     SQL QUERIES are save in .QPR files.

     Hint: When creating or editing these SQL reports, as well as the
     standard .FRX type reports, you will find the task MUCH easier if
     you have a mouse.  Most of the time you can get to all of the
     screen options with <TAB>.   If you are moving a field in an .FRX
     report, you can just hold the left button down and move things
     around.  Without a mouse, you probably will need a FoxPro manual
     to figure out all of the keystrokes required to move a field
     around.


     LETTERS
     -------
     You can select Letters from the browse mode, or the main menu
     B&B DOALL User's Guide                                         19

     where you will be prompted for your desired SORT and which
     records to SELECT.  Then you will see the "letters box" you can
     use your <TAB> and <Up/Down> arrows to select a letter.  When you
     <TAB> to the other options, like print, you'll notice that the
     last letter you selected is marked.  That is the letter that will
     be printed.


     To Edit a letter, <Enter> on a highlighted letter, or <TAB> to
     select the <Edit Letter> option.  You will be in the built-in
     editor to make changes to your letter.

     To Print a letter, <TAB> to print.

     Options will give you the opportunity to enter printer commands
     (for two tray printers) that will force tray one when printing
     page 1, and tray two for the remainder of the pages (Page 1 =
     Letterhead, Remaining Pages = Bond).

     Options will also allow you to turn the BELLRINGER option on.  If
     this option is turned on, AND if you have a character type field
     called bellringer in your data file, AND if there is data in it,
     your printer will PAUSE after printing the letter and the bell
     will ring.  This is for giving special handling to letters, such
     as entering "ADD CATALOG", or "HOLD" in bellringer to give you an
     opportunity to do something special with the letter.


     Letters - Adding Variables with brackets - use <<field name>>
     -------------------------------------------------------------
     To insert variable information into your letters, surround the
     variable name (such as Firstname) in double brackets -
     <<Firstname>>.  If you also want to print the Lastname, and if
     the Firstname field is 20 characters long, then you'll want to
     avoid any trailing spaces when the actual name is BOB.  To avoid
     the 17 spaces following "BOB", use the TRIM command and enter
     <<TRIM(Firstname)>> <<Lastname>> into your letter.  Note: you can
     preface the field name, firstname, with the file name as in:
     sample.firstname.  This tells B&B DOALL which file the data is
     located.  If you access many files and want to use the same
     letters for all of them, just use <<Firstname>> in your letter,
     but make sure that there is a Firstname field in each of your
     data files.


     Letters - Merge Other letters/text into main letter with ADDLTR()
     -----------------------------------------------------------------
     Besides inserting field/variable data using the << >> brackets,
     you can "insert" or merge letters into your main letter using the
     addltr() function.

     You accomplish this by using a function called
     <<addltr('ltrname')>>.  As an example, if you always want your
     letters to end a certain way, make either a DOS file called
     END.LTR, OR just add a letter to your letter file and give it a
     name of END.LTR.   Once you have made this letter, insert
     B&B DOALL User's Guide                                         20

     <<addltr('END.LTR')>> at the end of your main letter.  Then, when
     printing your main letter, and <<addltr('END.LTR')>> is
     encountered, the text from END.LTR will be inserted into your
     main.ltr.


     1. In example #1, you can automatically insert an existing DOS
     file by explicitly entering the DOS file name in your letter,
     like:
     <<addltr('c:\filename')>>


     2. In example #2, you can automatically insert the wording from
     one of your other letter files.  Letters are stored in the
     ltrs.dbf file, and you can store all of your letters in this
     file.  Use the same syntax as in example #1, but insert the name
     you assigned to the letter in quotes, like:
     <<addltr('form.ltr')>>

     3. In example #3, you can PERSONALIZE you letters to match the
     data in your file.  If your data file has any fields like
     AINTEREST, BINTEREST, CINTEREST, etc., and if you entered data
     into those fields that identified the person's interest, you can
     use ALLCODES instead of the actual letter name, like:
     <<addltr('ALLCODES')>>.

     For example, let's say you want to print letters to prospective
     customers, but these letters should only pertain to specific
     needs or interests of these customers (or prospective customers).
     You need two things to produce these letters.  Number one, you
     need to have fields in your data file called AINTEREST, BINTEREST
     ... ZINTEREST.  Number two, insert <<addltr('ALLCODES')>> into
     your letter.  This is what will happen DOALL encounters
     <addltr('ALLCODES')>>: If the record has "PENCILS" in the
     AINTEREST field, and "ERASERS" in the BINTEREST field, the
     LTRS.DBF file will be searched for a record with "PENCILS" in the
     name.  If not found, the current Operating System directory will
     be searched for a file called "PENCILS".   Any text from
     "PENCILS" (then "ERASERS") will be inserted into your letters.
     These letters can be product explanations, price lists, etc.

     Thus, your letters will contain text addressing specific customer
     interests.


     Letters - add SALES REPS/LOCAL OFFICES info.
     --------------------------------------------
     A sample REP.DBF file is provided with your system.  This file is
     intended to contain information on all of your sales personnel:
     Codes (usually initials), names, phone numbers, etc.  It can be
     used as an <F2> Lookup file if you have a field called REP in
     your main data file.

     But it can also be accessed to insert personalized endings into
     your letters.  When you print letters this REP file must be
     "open" and "related" to your main data file.   This is
     B&B DOALL User's Guide                                         21

     accomplished in the custom.prg file.  Refer to the section in
     custom.prg where the REP file is opened and the "SET RELATION"
     command is issued.

     NOTE: asterisks at the beginning of command lines in custom.prg
     should be removed.  Then you will need to compile custom.prg to
     make a new custom.fxp FoxPro file.   You need FoxPro and issue
     the "compile custom.prg" command.

     Here's how it works: If you have a value of "BBB" in the rep
     field of your main data file, when you put <<REP.rphone>> into
     your letter, the REP file will be searched for "BBB", and
     whatever value is in REP.rphone will be inserted into your
     letter.   The same holds true for <<REP.name>>, <<REP.address>>.

     You need 1) to have a character field called REP in the data file
     you are using, and 2) you need to have added the records for all
     of your sales reps or local offices in your file called: REP.DBF.



     Letters - add DISTRIBUTOR info.
     -------------------------------
     If you send letters to sales leads, you can automatically add a
     qualified distributor (or list of distributors) to your letter.
     Insert this in your letter: <<addltr('DISTRIBUTORS')>>.
     See how this coding appears in the sample DISTRIBUTOR letter.
     When this addltr code is encountered, the system then looks for a
     file called DISTRIBU.LTR, also provided in your sample letters to
     determine which <<variables>> to print.

     You need 1) to have a character field called DISTRIBU in the data
     file you are using, and 2) you need to have added the records for
     all of your distributors in your file called: DISTRIBU.DBF.






















     B&B DOALL User's Guide                                         22


     SAMPLE LETTER (DISTRIBUTOR in LTRS.DBF) SHOWING HOW TO
     INCLUDE DISTRIBUTOR DATA IN YOUR LETTERS:


     +---------------------------------------------------------------+
     |                       ====================                    |
     |                         YOUR LETTERHEAD                       |
     |                       ====================                    |
     |                                                               |
     |                                                               |
     |      DATE                                                     |
     |                                                               |
     |      NAME                                                     |
     |      ADDRESS                                                  |
     |      CITY  STATE  ZIP                                         |
     |                                                               |
     |                                                               |
     |      DEAR :                                                   |
     |                                                               |
     |                                                               |
     |                                                               |
     |      Hello, this is our ...                                   |
     |                                                               |
     |                                                               |
     |                                                               |
     |                                                               |
     |                                                               |
     |      Contact a Local Distributor:                             |
     |      ----------------------------                             |
     |      <<addltr('DISTRIBUTORS')>> looks for distribu.ltr for    |
     |                                 the <<field definitions>>     |
     |                                                               |
     |      Company: ABC Distrib.   Contact: Jim Jones               |
     |      Address: 123 Main St.  Chicago, IL 60001                 |
     |      etc.                                                     |
     |      etc.                                                     |
     |                                                               |
     |                                                               |
     |      Thank you for your interest ...                          |
     |                                                               |
     |      I.M. Manager                                             |
     |                                                               |
     |                                                               |
     |                                                               |
     +---------------------------------------------------------------+


     FOLLOW-UP REPORTS for SALES REP/LOCAL OFFICES
     FOLLOW-UP REPORTS for DISTRIBUTORS
     ---------------------------------------------
     If you send letters to sales leads, and reference Sales
     Reps/Local Offices in your letters, you can produce reports to
     your Sales Reps or Distributors that they can use to follow-up on
     your initial letter.

     B&B DOALL User's Guide                                         23


     Here's what you need to produce these reports: 1. You need a
     "REP" and/or "DISTRIBU" field in your main file (supplied in
     sample.dbf file).  2. You need a Rep.dbf and/or Distribu.dbf
     (these sample data base files are supplied with the demo).  3.
     And lastly, you need to enter your codes.  When you put a sales
     rep/local office code of JJ (Jim Jones) or CHICAGO in your main
     file, you also need to add a record for JJ or CHICAGO in your
     Rep.dbf.  How do you add a record to the Rep.dbf file? - Just use
     the Setup menu option to Select A New Data File and pick Rep.dbf.
     Add new records just like you would in your main file.

     Then, if you decide to print a report after printing letters,
     here is what happens: If a letter had a REP code of JJ (Jim
     Jones), the Rep.dbf will be scanned for the JJ code.  If the JJ
     value is found in the rep.dbf file, a report will be produced
     that you can send to Jim Jones CONTAINING A LISTING OF ALL
     LETTERS THAT YOU JUST PRINTED WITH JJ in the rep field.  If JJ is
     not found in the rep file, a report will be produced with a blank
     for the rep value.  The same process applies to the Distributor
     reports.

     If the REP field in the main file is 6 characters long, and you
     wish to make it 10 characters long, just use the File Maintenance
     menu option to Edit the fields.  Remember that you should also
     change the REP field in the Rep.dbf file the same way.

     NOTE: The layout of these reports are controlled by the FoxPro
     report format files DISTRIBU.FRX and REP.FRX, and can be modified
     by you.  Use the Edit Reports option and you can move data
     around, or add more Sales Lead information (like the specific
     interest the lead has), or move the distributor/sales rep
     name/address so that it appears in your window envelope.























     B&B DOALL User's Guide                                         24

     In the example below, three Letters are produced. Each Sales Lead
     has the DISTRIBUTOR and SALES REP/TERRITORY code shown under each
     letter.

          +-----------+        +-----------+        +-----------+
          |           |        |           |        |           |
          |to:A.Smith |        |to:B.Jones |        |to:C.Kline |
          |           |        |           |        |           |
          |           |        |           |        |           |
          |           |        |           |        |           |
          |           |        |           |        |           |
          +-----------+        +-----------+        +-----------+
          Distrib=Acme Co.     Distrib=Carter Co.   Distrib=Carter Co.
           Rep/Terr=BB          Rep/Terr=Main        Rep/Terr=BB



     After printing letters, you can print these reports of Sales
     Leads for your:

             DISTRIBUTORS               and/or SALES REP/OFFICES
            +- ACME Co.--+                 +--MAIN OFFICE-+
            |  A.Smith ..|                 |  B.Jones ... |
            |            |                 |              |
            |     +- CARTER Co.-+          |     +--- BB REP ----+
            |     | B.Jones ... |          |     | A.Smith ...   |
            |     | C.Kline ... |          |     | C.Kline ...   |
            |     |             |          |     |               |
            +-----|             |          +-----|               |
                  |             |                |               |
                  |             |                |               |
                  +-------------+                +---------------+



     Distributor Follow-up reports - coding issues
     Distributors - Restricted territories
     -------------------------------------
     If your distributors have restricted or protected territories,
     you would literally insert the appropriate distributor code for
     each record in your data file, like using "ACME" and "SMIT" to
     identify Acme and Smith Distributors.  In the DISTRIBU.DBF file
     add records for two distributors, "ACME" and "SMIT".


     Distributors - Overlapping territories
     --------------------------------------
     If a Sales Lead could have multiple distributors, you need to
     establish codes differently.  You can't identify multiple
     distributors in one field called DISTRIBU.  Or can you?  It is
     recommended that you set up your distributor code with a "left to
     right" order of preference.  For example, if your market is the
     United States, the largest, most universal reach for any of your
     distributors would be the United States.  This is how the codes
     would be set up in the DISTRIBU.DBF: distributors that cover your
     entire market, code them with a "U".  For distributors that cover
     B&B DOALL User's Guide                                         25

     just the Midwest, use a code like "UM".  For distributors that
     cover just Illinois, code them "UMIL".

     If you want your sales lead to know about all of the midwest
     distributors, put "UM" in the record.  Then all distributors with
     a "UM" will be printed in your letter (including those Illinois
     distributor records with UMIL).  If your sales lead record has a
     "UMIL" in it, then all distributors with just a "UMIL" will be
     printed.   Be careful, if you have a sales lead record with just
     a "U", all of your distributors starting with a "U" will be
     listed in your sales letter.

     This same technique can be used with zip codes. Several
     distributors may service the 601xx zip code area, and have a
     "601" code.  The Sales Lead, in the 60101 zip code, could have a
     distributor code of "601" to reference all the "601"
     distributors.

     When you print your follow-up reports for sales reps/local
     offices, you get one page per rep, with the individuals listed
     below.  When you print follow-up reports for distributors, you
     may have more than one distributor with the code "UM".  The
     result will be a report for "UM" distributor "Midwest Incorp."
     and another for "UM" distributor "Allstate Midwest".  The same
     individuals (coded "UM" in the distribu field) will be listed in
     each report.


     TICKLER LETTERS
     Tickler letters can be handled many different ways.  Since you
     can have any fields called ACTDATE1 and ACTION1 automatically
     filled-in with the letter date and (.LTR) file name (when a
     letter is produced), you can elect to send tickler letters (use
     Record Selection) to any record having a BLANK ACTION1 field.  Or
     you can use any Selection like: blank ADDDATE, or records with
     any value in any field.

     If you started printing letters, but only finish half, you could
     add a Flexi-select excluding those already receiving a letter
     such as: ACTDATE1 - not equal - DATE of FIRST LETTER RUN.

     If you want to manually control the production of a tickler
     letter, you could edit records to change the ACTDATE1 to a
     desired future date, and enter "TICKLER" in the ACTION1 field.

     Use your record selection to print letters for records with
     ACTION1='Tickler' and ACTDATE1="today's date", or greater than
     today's date, etc.



     PROMOTION LETTERS
     We strongly urge the use of an interest code (or multiple
     interest1 and interest2 fields, etc.) in your data file.  When
     you communicate with this Sales Lead (or get a postcard back),
     enter PLANE390 if he's interested in that model of plane.
     B&B DOALL User's Guide                                         26

     If you have a promotion or a special sale price planned for MODEL
     #390 airplanes, you could develop a promotion letter called
     390PROMO, then print letters for Sales Leads having an interest
     code of PLANE390.

     QUOTE LETTERS
     If you put quote dollars (and maybe the quantity for the quote)
     in your data file, you can reference this amount in a special
     quote letter you can develop (see <<variables>>)


     What letter was sent when??? - ACTION FIELDS
     --------------------------------------------
     When producing letters, you may want to keep track of the last
     letter sent and the date sent.  The system will sense if you have
     a character type field in your data file called ACTION1, and a
     date type field called ACTDATE1, after your letter is printed you
     will be prompted if you want to put the letter "name" and the
     current date into these two fields automatically.  If multiple
     letters are produced at one time, and you respond yes the first
     time, these two fields will be updated automatically for the rest
     of the letters.

     If you want to keep track of the last four letters, put the
     following fields in your data file: ACTION2, ACTION3, ACTION4,
     ACTDATE2, ACTDATE3 and ACTDATE4.  If these fields exist, your B&B
     system will automatically move the data that was in ACTION1, and
     move it to ACTION2, ACTION2 data will be moved to ACTION3, and so
     on.  The same is also true for the date type fields.



     MULTIPLE LABELS - for ONE RECORD
     --------------------------------
     If you select "Labels" from the menu, you can print multiple
     labels for one record.  For example, if your data file contained
     records of garments (price, style, size), and you wanted to print
     200 price tags for record # 10 (Button Down Shirt), Use FLEXI-
     SELECT to select STYLE='Button Down', and then produce labels.

     You can create any type of label format, in any number across to
     make multi-part price tags, company labels, whatever.


     PRINTING TIPS
     =============

     CONTROLLING PRINTER -
     LABELS FROM DISK FILE
     ---------------------
     When you have selected to send labels or a report to a disk file,
     you can control how the data appears by controlling the printer.
     For example, with H/P laser printers, you can manipulate the
     printer to control labels output:

     1. Press the ON-LINE button to take Laser Printer OFF-LINE
     B&B DOALL User's Guide                                         27

     2. If you want to print 12 characters per inch instead of 10
     (commonly needed when trying to printing and fit 3-across labels
     on 8-1/2" x 11" stock).  Press menu button to get to font #, use
     the +/- buttons to change font # to 2.  Press Reset button to
     make the asterisk appear on right (default).
     3. Press menu button again, until you get to Lines Per Page,
     press "+" button to increase to 63 lines per pages, and press
     reset button again.  Keep pressing menu button, Until READY
     appears.  Put back ON-LINE.

     To change back to original status, do above using "+", "-" keys
     to bring font to "0" and lines per page to "60".

     EXTRA SHEETS EJECT
     ------------------
     On some printers, when printing reports, labels, or letters and
     also define a top margin greater than 0, blank lines may be fed
     to your printer for the next sheet.  You can avoid this by
     inserting extra lines at the top when initially defining your
     letters or labels.

     PRINTING BARCODES ON LABELS
     ===========================
     1) For Laser Printers, make sure you selected Laser during
     installation.  B&B DOALL's Bar Codes have been U.S.Postal Service
     certified when using a Hewlett-Packard compatible Laser Jet.
     The barcodes require that your printer utilize the PCL Language
     and associated ESCAPE code sequences.

     BUT, since printer models are constantly changing (even Hewlett
     Packard), you should print a sample of the barcode with your
     printer and submit the sample to a major Post Office in your
     area.  They can confirm that the bar code is acceptable.  DO THIS
     PRIOR TO PRINTING HUNDREDS OF BARCODES THAT MAY NOT BE
     ACCEPTABLE.  B&B SYSTEMS ARE NOT RESPONSIBLE FOR ANY EXPENSES
     INCURRED IF YOU DECIDE TO RISK NOT HAVING YOUR BARCODES VERIFIED.

     Also, barcode location on mailing pieces are critical, please see
     the U.S. Postal Service for information on placement.

     TO PRINT BARCODES:
     2) Edit a Label Form and enter: BARCODE(#) on one of the lines
     desired.  The line where BARCODE(#) is entered determines
     vertical placement.  Horizontal placement is determined by the #
     within parentheses.  # is the number of inches (in tenths) to
     indent from the left.   For Example: barcode(30) on the fifth
     line will print 5 lines down, and will print the barcode 3 inches
     from the left (30/10).

     3) Zip Codes NEED TO BE 9 DIGIT ZIP CODES.  That is what is the
     barcode is, graphic representation of the 9 digits.




     PHONE DIALING W/MODEM
     B&B DOALL User's Guide                                         28

     ---------------------
     If you have a modem, and would like to have your B&B system dial
     phone numbers for you, here is how you set it up:  Connect a
     modem to the phone line you will be using.  Have a telephone
     available on that same line (You can connect a phone to the
     "PHONE" jack on the back of most modems).

     When you are in the Browse screen, use <ALT>-D or your mouse to
     highlight the DIAL PHONE option.  Your file will be searched for
     any fields that have the word "PHONE" in them.  If only one field
     is found, and a phone number exists, dialing will start.  If
     multiple fields like HOMEPHONE and BUSPHONE are found with phone
     numbers, they will be displayed for you to select the one to
     dial.

     Select one of the numbers to start dialing, and you'll hear the
     modem dial.  If you have a "MEMO" type field in your data base,
     you will also be prompted for a TOPIC of the call.  You can enter
     "Left Message" and this will be inserted into the memo notes.  If
     you enter ? it won't be found in the topic.dbf data file and you
     will be presented with a list of topics and you can just select
     and <Enter>.  You will also be asked if you want the date and
     time inserted for you.  You will then be presented with the memo
     editor screen, and you can expand on your notes while talking.

     You can hang up the phone at any time, and then save your notes.

     NOTE: If you want to dial multiple numbers at one time, see the
     file custom.prg.  In it, move asterisks to change the command ON
     KEY LABEL F4 DO PHONE WITH 'ONE',  to WITH 'ALL'.  Then compile
     this file to make a new .FXP file.  This will allow you to skip
     through all of the records, or those you've selected in Flexi-
     SELECT, and display the phone numbers one by one.

     If your file has a date type field called CALLBACK, you will have
     the option of updating the callback date.  After your phone call,
     you will be shown a list of "future time values", such as one-
     week, one month, or two months to have entered into the callback
     date.  If the current date is January 1 and you wish to be
     reminded to callback in one month, select one month from the
     callback.dbf list and February 1 will be entered into the
     callback field of your file.  (See section regarding callback
     reminders during startup).

     Note that in the list of "future time values", the current
     callback value is at the bottom of the window.  If you don't want
     to change the current value, use <ESC>ape.  The list of future
     time values are stored in a data file called callback.dbf.  If
     you are not satisfied with selecting between a callback period of
     one week or two weeks, and you want to add a future callback of
     10 days, add a record to this callback.dbf file by Selecting a
     New Data File from the setup menu.




     B&B DOALL User's Guide                                         29

     DUPLICATE CHECKING
     ------------------
     B&B Systems offers both SOUNDEX (sound-a-like) and EXACT testing
     of records in your file.   Exact matching will NOT uncover
     differences in spelling.  If you have two records, one with a
     last name of SCHULTZ, and one with SHULTS (with matching first
     names and city names) exact matching will not identify them as
     duplicates, but Sound-alike may.  NOTE: The Soundex process
     generally ignores vowels.

     Once you've selected the type of matching you prefer, the next
     step is to select WHICH RECORDS and WHICH FIELDS of data are
     compared.  If you are going to compare phone numbers, and have
     many records with no phone numbers, you may want to add a Flexi-
     Select to pick phone numbers that ARE NOT BLANK
     (ie. PHONE<>'        ').   This way you won't see a large number
     of duplicate records that have empty phone numbers.

     The system will provide a default combination of fields (2nd, 3rd
     and 4th in your file).  But this is only a sample.  You can be
     more specific based on your needs.  For example, if you do not
     want two records with the same address, you can select the
     address field.  <INS> to add the field(s) you want to check for
     duplicates.

     You can also opt for your B&B System to automatically mark all
     duplicate records for deletion.  But it is suggested that you
     print a report of the duplicates BEFORE opting to delete them
     automatically.  Check the report first for accuracy and then
     re-run the process with the automatic deletion feature turned-on.
     If there are several records you prefer NOT to delete, note which
     ones on the report, process the automatic deletions, then go back
     and Recall them from deletion status individually in the Edit
     mode  NOTE: Records marked for deletion have a small "diamond" on
     the left.  You also have the option of assuming that the newest
     record is the "good" record, which reviews the file in reverse
     order (Last record=Good record).

     TIP: You can add (<INS>ert) a new set of fields to check for
     duplicates such as: COMPANY and LASTNAME.  If YOU WANT duplicates
     OF THE SAME COMPANY WHEN THE LASTNAMES ARE DIFFERENT, this
     process is ok because BOTH company and lastname fields will need
     to match in order to be considered a duplicate.  If you don't
     want duplicates for one company, but still want the company name
     and lastname to appear on the report, this is what you can do:
     Pressing <E> for the <E>dit option will allow you to change three
     items,  the HEADING DEFINITION (top line of the report), the
     PRINT DEFINITION (fields actually printed), and the fields to
     check for DUPLICATION (also the fields displayed on your screen).
     Just remove the reference to LASTNAME in the DUPLICATION listing
     of fields.

     If the DUPLICATION line is COMPANY+LASTNAME, you can edit the
     line to appear as follows:COMPANY.  Only Company values will be
     checked for duplication, while company & lastnames are printed on
     the report.
     B&B DOALL User's Guide                                         30


     PROPER CASE
     Also, if you cannot rely on the data being in Proper Case, then
     you may want to consider changing COMPANY to UPPER(COMPANY).
     This will force the comparison to be based totally on upper case.

     INDEX PREPARATION
     If you have a large data file, please remember that a new index
     file is required to be built each time for ALL SOUNDEX type
     comparisons, ALL EXACT matches that involve multiple fields, and
     any matches using UPPER().













































     B&B DOALL User's Guide                                         31

     IMPORT/EXPORT
     ---------------
     B&B Systems can READ or WRITE files from/for use by, other
     sources (mainframe computer, 1-2-3, word processors, mail-merge,
     Dbase, R-Base, list vendors, etc.).

     Normally, when exporting or importing, you will be using the
     default Master Data file.  But you will see that in some of the
     "pop-up" options where you can access other data files for lookup
     purposes, you can export or import to other .dbf files.  For
     example, you can import records into the Zip.dbf file.  If you
     only enter records for Illinois, you could Import a file of
     Illinois Zip/City/State data into your Zip.dbf file.  You would
     be wasting a lot of Disk Space if you imported all 43,000 USA zip
     codes.  If you expand into Iowa, import Iowa zip codes at a later
     date.

     IMPORT
     ------
     B&B Systems will import many types of data, word processing and
     spreadsheet files, in addition to the standard ASCII files.

     Purchased Lists
     ---------------
     If you purchase data for your System from a vendor, ask if they
     will supply the data in one of the formats (such as ASCII comma
     delimited) that B&B Systems can Import, and if ASCII, if they
     will supply the data in the order (which field comes 1st, 2nd,
     etc.) shown in the structure of the .dbf file in the Appendix.
     If you want to see an example of how the Import file should
     appear, Export a file from your current file and name it 'TEST'.
     Compare it with the new import file for similar structure.  If
     importing .DBF type files, order is not important, but field
     names should match.

     TIP: If you import files regularly and your master file has an
     Add Date, unless you add it to the import file first, is normally
     missing.  You can use Search/Replace to enter the Add Date by
     Flexi-Selecting all records with a blank Add Date, then
     Search/Replace with current date. When adding records in Add
     Mode, Add Date is assumed to be today's date.

     EXPORT
     ------
     There are several additional options available before exporting
     your file.  You will be presented with the FLEXI-SORT option to
     allow you to sort your file in a specific order.  The
     FLEXI-SELECT option will allow you to select only specific
     records for your export file.

     And lastly, A VERY POWERFUL OPTION.  You will be asked if you
     would like to change the 1) sequence of your output fields AND/OR
     2) Which fields are included.  For example, you may prefer your
     file to have the Company Name in front of the Last Name. OR, you
     may not wish to include Sales or Added-to-file-date field in your
     export file.  This option may be necessary if the system using
     B&B DOALL User's Guide                                         32

     this file requires a certain sequence of fields.

     If you select to export an ASCII Comma Delimited field, you can
     also opt to select a different delimiter (the character that
     separates each field) than a comma.  For example, you may use a
     software package that needs the '@' character to mark the
     beginning and ending of fields.


     ASCII files
     -----------
     There are two common types of ASCII file formats: COMMA DELIMITED
     and SDF(Standard Data Format).   ASCII refers to the fact that
     ONLY Normal ASCII characters (numbers or letters of the alphabet,
     upper or lower case, and a limited number of special codes)
     appear in the file.  There are no special control or binary
     codes.  In both types of ASCII files, every record is a separate
     line, with records separated by a line feed ASCII(10) and
     carriage return ASCII(13).  The remaining difference between
     these two types of files is how the data appears on each line.

     You can test if a file is ASCII by reviewing the file on your
     screen.  At the DOS prompt, enter C:>TYPE FILENAME.TXT.  If every
     character is legible (no special characters, unusual spacing, no
     beeps from your computer), then it is probably an ASCII file.

     Most other programs, such as Lotus 1-2-3, R-Base, Symphony, and
     most MailMerge programs can use, or produce, a file in at least
     one of these formats.


     COMMA DELIMITED files contain commas to separate fields.  Many
     Word Processing and Data Base Management software handle this
     type of file. Commonly double quotes (") are used to enclose
     character type fields.  Numeric fields are left alone.  Also,
     numeric fields do not contain commas to delineate thousands.
     This transfer method saves space, and is fine if the number, AND
     the order of the fields is the same in the FROM and TO systems.


     STANDARD DATA FORMAT files contain fields that start in specific
     positions no matter how much data the field actually contains
     (common for Spreadsheet programs).  Field 1 starts in Column 1
     and field 2 starts in Column 12(?) even if field 1 is blank.
     This method is necessary if you need to change the length of
     fields, OR add/delete fields because the FROM or TO system have
     differing file structures.  The reason is: since all data is in
     columns, you can use a word processor to shorten/eliminate/add
     columns.

     For example, if you require that the export file ADDRESS be 20
     characters long, instead of 25, you need to use your word
     processor to DELETE a 'Block' of text 5 columns wide.  You will
     need to become familiar with 'Blocking' and setting the
     'Blocking' mode to columnar (ie. the text you block will appear
     to be vertical columns, and excludes text to the left and right
     B&B DOALL User's Guide                                         33

     of your 'Blocking' markers).  In Wordstar, set this mode with
     Ctrl-K-N.

     If, in the prior example, you need an address 30 characters long,
     you would INSERT a 'Block' of blank text 5 characters wide at the
     25th position of the address.


     COMMA DELIMITED file example
     -----------------------------------------------------------------
     |   Smith, Joe, 123 Main ST, New York, NY, 10000, etc.          |
     |   Jones, William, 666 E St, Elmhurst, IL, 60011, etc.         |
     -----------------------------------------------------------------

     STANDARD DATA FORMAT file example
     -----------------------------------------------------------------
     |   Smith    Joe     123 Main ST    New York    NY   10000,etc. |
     |   Jones    William 666 E St       Elmhurst    IL   60011,etc. |
     -----------------------------------------------------------------


     IMPORT/EXPORT FROM DATA BASES, INCLUDING SQL
     Most software packages support the writing and reading of
     standard ASCII files, and SQL data bases are no exception.  Using
     Oracle SQL version 5.1 as an example, ASCII files can be
     exported, or written from SQL by using Oracle's SPOOL <filename>
     command; issuing SELECT <field names,...> statement; and SPOOL
     OFF after writing the file.  Don't forget the YYYYMMDD ASCII date
     format.  To read an ASCII file into SQL, use Oracle's ODL
     utility.  By writing a copy of B&B's records, then reading them
     into SQL (and vice versa), you can transfer data back and forth.
     If the number of fields are different on the data bases (ie. you
     need to 'write' a home AND business phone number but only have
     one phone number, set up a 'blank' field with a length of 1
     character.  Then when defining the fields to be written, enter
     the name for the 'blank' field wherever you need a field, but
     don't have one).  Also, when any data is changed, re-index
     (housekeeping) your B&B records before using them.

     FILE UPDATING
     REMOTE OFFICES vs CENTRAL OFFICES
     =================================
     With DOALL, you also have some extra options that allow you to
     easily transfer data back and forth between REMOTE OFFICES or
     sales personnel and CENTRAL OFFICES.  This assumes that the data
     structures in both locations have the same field names.

     Here is how you can use these options.  First of all, to use
     these options you will need to select a field, like OFFICE or
     SALESREP or REP, that uniquely identifies the ownership of each
     record.

     REMOTE
     ------
     Copy Option -
     Let's say the CENTRAL OFFICE wants updated information on your
     B&B DOALL User's Guide                                         34

     contacts or sales results.  If you are using DOALL remotely, you
     can make a copy of your local file to send or transmit to the
     central office.    You will be asked for the OFFICE or REP code,
     and all records with that local code will be copied to a file.
     For example, if the REP field is selected and the REP code is ML
     (Michael Lewis), all records with ML in the REP field will be
     copied to a file called ML.REP.

     Merge Option -
     In addition, if your CENTRAL OFFICE has added some accounts, or
     has updated information for you, you can Merge that file into
     your remote file.  When they send you a new ML.REP file, select
     the Merge function to replace all the records having ML in the
     REP field with the new ML.REP file from the CENTRAL OFFICE.
     Note: this process will delete all existing records with ML in
     the REP field, and add the records in ML.REP, so make sure that
     the ML.REP file from the office is the "latest" information (say,
     after you uploaded a file the day before, and they made changes
     to it).

     CENTRAL OFFICE
     --------------
     Copy Option -
     You have the option of making a copy of the "ML" records from the
     CENTRAL file.  The CENTRAL office personnel can make it
     themselves, or, if the Michael Lewis is allowed access to the
     central file over phone lines, Michael can produce the file and
     download it himself.

     Merge Option -
     The CENTRAL OFFICE may have a procedure where all Sales Reps
     submit copies of their files every month.  If you collect these
     files, say ML.REP, SF.REP and RT.REP, have them put in one
     directory. DOALL will sense the existence of multiple .REP files
     and will merge the data in each of these files by deleting all
     records with the ML REP code, then adding the ML.REP file, then
     deleting the SF records, etc.  The .REP files are then deleted
     automatically.
     Note: make sure that there are no duplicate REP VALUES, like
     Michael Lewis and Mickey Lisbon.

     MAINTENANCE
     ===========
     DELETING RECORDS, PACKING, and REINDEXING issues
     ------------------------------------------------
     When you delete records (usually with CTRL-T in Browse), they are
     "marked" as deleted.  They are not physically removed until you
     select the "PACK" option in file maintenance.  Until you Pack,
     you can always "undelete" records with another CTRL-T.  When you
     have records that appear in "unsorted" order, it can usually mean
     that the .CDX index file is bad.  If you erase your
     <filename>.CDX file, a new .CDX file will be created for you
     automatically when you start your system.  On a network, be aware
     that DOALL will not allow access to the file for packing or
     reindexing unless you are the only one using it.

     B&B DOALL User's Guide                                         35

     DELETE or UNDELETE GROUPS OF RECORDS
     ------------------------------------
     This is a convenient method of marking large groups of records as
     having either deleted or undeleted status, instead of doing so
     individually in the browse screen.  Marking records for deletion
     does not permanently remove them.  They will be permanently
     removed when the file is packed.

     You will be provided with the Flexi-Select screen.  From this
     selection screen you can select field(s) AND enter the values for
     each field that you are interested in.  Records matching those
     values will be selected (For more information, see Flexi-Select)

     To review these records BEFORE deleting them, select Browse and
     the same record selection in Flexi-Select.  Browsing them gives
     you the opportunity to confirm this process of marking/unmarking
     records for deletion.


     ADD/DELETE FIELDS
     =================
     If you decide to add or subtract fields in File Maintenance -
     Modify Structure, you will be asked if you want to delete the
     file:????SORT.MEM & ????????.CDX.  The ???? refers to the 1st 4
     characters of the .DBF filename.  A new .CDX file will be created
     for you, and you may need to re-define any special sorts you had
     added.  Also, some Flexi-Select options may no longer be relevant
     if you delete fields that were once used in the definition.


     BROWSE SCREEN TIPS
     ==================
     SPLIT BROWSE SCREEN TIP: When in a BROWSE screen, you can "split"
     the screen into two sections.  Let's say you want the last name
     or manufacturer name to appear "fixed" in one browse screen on
     the left, so that you can <TAB> through the rest of the fields on
     the right.  How? Use your mouse to the little double arrow at the
     bottom and move to the right to make your partition.


     SPLIT BROWSE SCREEN EXAMPLE:

      (stays fixed)        (While you move thru fields)
     -----------------   ----------------------------------
      COMPANY             <--- LAST NAME  |   PHONE   ---->
     -----------------   ----------------------------------
      ABC Company         Jim Jones          555-2222
      XYZ Company         John Smith         333-2222
      123 Company         Jane Doe           111-2222
     -----------------   ----------------------------------



     SHORTEN FIELDS BROWSE SCREEN TIP: Also, when in any BROWSE
     screen, you can shorten the width of displayed fields.  If your
     CITY field is 30 characters long, and most of the cities are less
     B&B DOALL User's Guide                                         36

     than 20, you can display just 20 so that more fields will fit on
     your screen (This will not effect how much data is stored in the
     field, only how much is displayed). HOW? Use your mouse to the
     little divider line between field names (at the top of the
     column) and drag the divider left.

     MOVE FIELDS BROWSE SCREEN TIP: Also, when in a BROWSE screen, you
     can move a field to a different location.  You can move ZIP to
     the far left.  HOW? Use your mouse to the field name (at the top
     of the column) and drag the field name left or right.


     PRIOR TO PRINT JOBS
     -------------------
     Prior to sending most jobs to the printer, you will be asked if
     you would like to send control codes which will change
     configuration of the printer.

     <YES> will send some basic printer codes, like, lines per page,
     line per inch, etc.  You will then be able to <PRINT> use the
     default printer, or a different printer if you pick <SELECT>.  If
     you <SELECT> a different printer, you'll see an option to ADD a
     printer to the list of selected printers.  If you <ENTER> or
     mouse click on this option, you will see a list of printers.
     Enter a "Y" in the field SELECTED to add a printer to the list.
     You can also define which printer is the default printer, by
     entering "Y" in the DEFAULT field.

     <NO> will not send control codes and will use the current state
     of the printer.

     <CUSTOM> will give you more control, or if you need to use a
     PostScript printer.

     Postscript Printers - set up
     ----------------------------
     To set up a Postscript printer, there are several steps required.

     ONE TIME
     1. Select the option to "ADD a printer" to the list of selected
     printers.
     2. Find "POSTSCRIPT" in the list of printers, and put a "Y" in
     the field SELECTED. You can also include a "Y" in the DEFAULT
     field if you desire this printer to be the default.
     3. The list of selected printers will be re-displayed. <ENTER> or
     mouse click on it.
     4. You will be presented with a custom "Printer Driver Setup"
     screen.
     5. Select <NEW> and use arrows to find the Postscript printer in
     the list of printers one more time.  Select it and <Enter>.
     6. Enter a setup name like: POSTSCRIPT 10th FLOOR.
     7. Confirm that proper font, point size, etc. and choose <OK>.
     8. Arrow down to the newly added Postscript driver in the list of
     drivers and <ENTER> on <SET DEFAULT>.

     TO SEND CODES
     B&B DOALL User's Guide                                         37

     9. Choose <SET> to send the control codes to the printer.



     PRINTER MAINTENANCE MENU OPTION
     -------------------------------
     You can use the EDIT option to actually change the control codes
     that are sent to your printer.  For example, if you have a
     printer that is not in the list of selected printers, and you
     want to change the values in one of the printer records
     (P_CODES.DBF), see your printer manual for the control codes.
     They are usually shown as decimal codes.  If you want to change
     the codes used to reset your printer, enter the decimal codes as
     CHR(##) CHR(##) CHR(##).  The system will convert the CHR() value
     for you.

     Note: you may notice that some of these codes may have curly
     brackets around a number symbol:{#}.  This indicates that the
     code is not quite set up yet.  For example, there is no way we
     know how long your page length needs to be defined, so under page
     length you may see these brackets.  To have the page length
     feature used successfully, you need to replace the # and curly
     brackets with the number is decimal code.  62 would be
     CHR(54)CHR(50).


     You can also sent the setup codes to your printer.
     You can use this option to force your printer into various print
     modes, including setting up your printer for other systems, in
     addition to your B&B systems.  Once your printer has received a
     Control Code, it remains in effect until the printer is turned
     off, or new Codes are sent.


     SETUP OPTIONS
     -------------
     TOGGLE SCREEN DISPLAY allows you to put more lines of data on the
     screen, assuming your monitor and video card will support 43
     lines on an EGA system, and 50 lines on a VGA system.  Handy to
     see more data when in the Browse screen.

     CHANGE MONITOR DISPLAY/COLOR type allows selection of monochrome,
     color, or laptop type video displays.  You can use this option to
     select a color combination that makes your screen easiest to use.
     You can select the Standard defaults for B&B Systems, or
     Customize your own colors, or default to the FoxPro defaults.
     These color definitions are saved in the file COLORDEF.DBF


     SELECT FIELD TO CHECK for DUPLICATES allows you to select say,
     lastname, so that when adding records,  if a record with a
     similar last name appears, a list of the similar records will be
     displayed for you.  In addition, you will be asked which sort
     should be the default sort when duplicates are found.  For
     example, you may wish to check LASTNAME for duplicates, but when
     a duplicate appears, you may want more than just a lastname sort.
     B&B DOALL User's Guide                                         38

     You may want LASTNAME and FIRSTNAME, OR you may want LASTNAME and
     COMPANY.


     MODIFY ADD SCREEN.  An add screen is made for you when you first
     add a record.  This file name is <dbf file name>.PRG.  If you
     compile this file with FOXPRO, you can have extensive data
     control, like automatic popup fields for blank entries, allowing
     only a range of values (1 thru 1,000), allowing only numeric
     values (PICT '@9'), etc.  If you have foxpro, run foxprol and
     select Compile under the Program menu selection.  For extended
     memory versions of B&B Systems, run foxprolx instead.

     MAKE/EDIT a .REP DATA FILE USED WHEN ADDING RECORDS.  Whenever
     you add records, if a .dbf type file, with a .REP file extension
     exists, values in this file will copied into fields with the same
     name in your add screen.  If you add "IL" (Illinois) to the state
     field in this .REP file, whenever you add a record, the state
     field in the new record will contain "IL" automatically.

     CHANGE MEMO FIELD DISPLAY in BROWSE.  If your data file has a
     MEMO type field, you can elect to have the contents of this memo
     field display automatically when you move to different records
     while in the Browse mode.  You can also elect to use the last 5
     lines on the screen for the remarks, or the last 10 lines on the
     screen.

     If you have MEMO TYPE FIELDS, you can import files directly into
     memo fields without re-typing.  Select the MEMO option from the
     top menu in the Browse screen and you can import any file of
     notes, letters, any reference material.  Conversely, if you have
     data in a memo field, you can export the information to a
     separate file.

     BROWSE SCREEN TIPS
     ==================
     SPLIT BROWSE SCREEN TIP: When in a BROWSE screen, you can "split"
     the screen into two sections.  Let's say you want the last name
     or manufacturer name to appear "fixed" in one browse screen on
     the left, so that you can <TAB> through the rest of the fields on
     the right.  How? Use your mouse to the little double arrow at the
     bottom and move to the right to make your partition.


     SPLIT BROWSE SCREEN EXAMPLE:

      (stays fixed)        (While you move thru fields)
     -----------------   ----------------------------------
      COMPANY             <--- LAST NAME  |   PHONE   ---->
     -----------------   ----------------------------------
      ABC Company         Jim Jones          555-2222
      XYZ Company         John Smith         333-2222
      123 Company         Jane Doe           111-2222
     -----------------   ----------------------------------


     B&B DOALL User's Guide                                         39

     SHORTEN FIELDS BROWSE SCREEN TIP: Also, when in any BROWSE
     screen, you can shorten the width of displayed fields.  If your
     CITY field is 30 characters long, and most of the cities are less
     than 20, you can display just 20 so that more fields will fit on
     your screen (This will not effect how much data is stored in the
     field, only how much is displayed). HOW? Use your mouse to the
     little divider line between field names (at the top of the
     column) and drag the divider left.

     MOVE FIELDS BROWSE SCREEN TIP: Also, when in a BROWSE screen, you
     can move a field to a different location.  You can move ZIP to
     the far left.  HOW? Use your mouse to the field name (at the top
     of the column) and drag the field name left or right.

     OTHER OPTIONS
     -------------
     PRINTER TRAY CONTROL - If you have a dual tray printer, you can
     define printer control codes that will select the top tray for
     page 1 of letters (letterhead) and select the bottom tray for
     subsequent letter pages.

     CALLBACK DATE SPAN - If you have a callback date field in your
     file, and if you have ANY callback dates pending (in the future),
     you will be asked if you would like to review these records in a
     browse screen.  If you don't want to see the callbacks six months
     from now, and only want to see those within the next two weeks,
     you can enter 14 days here.


     HOW TO USE DOALL WITH SALES LEADS
     ---------------------------------
     B&B DOALL can be your Marketing Mailings Manager.  It can keep
     track of all of your customer data now kept in separate files or
     logs.   Report on Sales Leads cultivated as a result of specific
     promotions (use a "Source" code field), or report on Leads with
     the highest sales potential and likelihood of closing (use a
     "Qualified" code field).   Track time and dollars spent
     cultivating sales, etc.  This manual will give you some hints on
     how to collect your sales lead information and if you are already
     collecting it in a .dbf type file, how to access that file, or
     even "import" your separate files into one file we'll call
     SALELEAD.

     DON'T SEPARATE FILES....PICK A FIELD, ANY FIELD
     It pays to look ahead on how you expect to use your file.  If you
     have one master file, you can always 'dissect' (not physically)
     your file into sub-files, and thus use one file for multiple
     purposes.   With DOALL, you can use Flexi-Select to just pick
     records where interest='BC' (your Bridge Club), and just
     concentrate on those.

     Maybe you need to add a field to handle 'I' Industrial or 'S'
     Special Handling accounts.  For large volume Mailers, any two
     character field can be used to contain the carrier route
     information.

     B&B DOALL User's Guide                                         40

     It is not recommended that you have separate files for separate
     purposes.  Use values in fields to distinguish record types.
     It is not recommended for this reason: Having all records in one
     file will be an advantage when it comes to maintenance.  When you
     edit a record in one file (address change), a similar record in
     another file will become outdated. Instead, all records, should
     remain in one main file, with codes indicating uses.


     DEVELOPING and PROCESSING SALES LEADS
     Here is a example of the Postcard method to develop and process
     Sales Leads.  This postcard is designed to fit many sales
     activities, such as handouts at seminars & expositions, mailing
     stuffers, and for recording office or field calls.  When ready
     for processing, plan ahead by designing the format to follow your
     add and edit screens (Easier for everyone to input data).  Print
     them on standard 3.5 x 5.5 postcard stock, with your company name
     and address on the front and it becomes an easy-to-return self
     mailer for a Sales Lead.  Consider having it printed with
     Business Reply Mail pre-paid postage,  available from the U.S.
     Post Office for an annual fee and a per piece handling fee.
     (They can still be used as an office form to record leads, you
     won't incur postage costs).


                            SALES LEAD POSTCARD EXAMPLE

     +--------------------------------------------------------------+
     |                           ABC Company                        |
     |                                                              |
     |                                                              |
     |   Name ___________________________  Title ________________   |
     |                                                              |
     |   Company ________________________  Phone ________________   |
     |                                                              |
     |   Address _____________________ City ________ ST ___ Zip____ |
     |                                                              |
     |   Contact me regarding:                                      |
     |               [ ] MODEL#1 Airplanes    [ ] MODEL#2 Planes    |
     |               [ ] #245 parachutes      [ ] etc.              |
     |                                                              |
     |                                                              |
     |   Comments:_____________________________________________     |
     |            _____________________________________________     |
     |                                                              |
     +--------------------------------------------------------------+
          (REVERSE SIDE should be self-addressed to ABC Company)

     Set up the Product Interest check-off boxes to resemble your
     Product/Services.  Once returned, you can easily enter data from
     these cards.


     ANALYZE REASONS FOR LOST SALES
     Analyze why you lose sales.  Use a Miscellaneous code to assign a
     reason why a sale was lost (ie. Q=perceived as being lower in
     B&B DOALL User's Guide                                         41

     Quality, P=higher in Price, etc.).  Also indicate in a field the
     potential sale size,  Then you can later review the impact of
     lost sales by using Flexi-Select to select records with any of
     these lost sales codes.  Sort by this code, and print this misc.
     code plus any potential sales field.  The frequency and impact of
     each code will tell a story.

     SOURCE - Measure Marketing Program Effectiveness
     A Source field can be added for tracking the origin of each Sales
     Lead.  Indicate the type of media (ie. NE=Newspapers, RA=Radio)
     that produced the Lead, or pinpoint Leads developed as the result
     of specific marketing programs.  For example, Promotions for
     program #1 can be coded 'P1', Program #2, 'P2', etc., Cold Calls
     'C1', or Direct Mail 'D1'.  The potential combinations are
     numerous.  You can even use codes that indicate the timing of
     your promotion, by using month & year in your code.  Your fall
     and spring promotions can then be easily 'picked out'.
     Summarizing sales, expenses and other data could provide an
     indicator of where your marketing dollars are being spent, which
     ones develop the most Leads (and the ones with the most
     potential) and possibly where your marketing dollars should
     spent.


































     B&B DOALL User's Guide                                         42

     GENERAL COMPUTER OPERATIONS
     ---------------------------

     BACKUP
     ------
     Make BACKUP copies often (at least of your *.dbf files).  If you
     have many transactions per day, you should backup daily, if not
     twice daily.  You should also have multiple backup copies so that
     you have at least one backup that is less than one day old,  one
     a week old,  one a month old, etc.

     Backup hardware has become available in many different formats.
     External units can be moved around to perform backup on multiple
     PC's.


     LETTERS VS. LABELS
     ------------------
     If you are looking for options other than affixing labels to
     envelopes, B&B Systems urges you to use personalized letters
     which fit into window envelopes eliminating matching labels with
     letters, allows professional customized letters, and reduces
     manpower for mailings.



     CUSTOMIZING SERVICE
     -------------------
     If you wish different fields on your screen, or would like some
     other modification made to your B&B System, we will be happy to
     discuss the cost of your desired changes.


     EXISTING FILE CONVERSION SERVICE
     --------------------------------
     If you currently have a file of mailing records (from a 'list'
     vendor, 1-2-3 files, ASCII files, etc.), but do not know how to
     convert them to the B&B format/structure (see Appendix), B&B will
     convert this file for you at ten cents per name.  Send the file
     electronically to B&B's electronic Bulletin Board, P.C. Manager,
     or send on an IBM 5 1/4" 360K floppy disk/or 3-1/2" 1.4m disk to
     B&B Systems.  The approximate time required is 2 weeks.


     YELLOW PAGES NAMES/ADDRESSES by ZIP CODE or SIC Code
     ----------------------------------------------------
     B&B Systems can provide you with Company Name - Address - City -
     State - Zip - SIC Code data from the Yellow Pages for any ZIP
     CODE or STATE or SIC (Standard Industrial Code) that you supply
     to us.  The costs vary, depending on the quantity desired.  Leave
     a message on B&B's Bulletin Board, PC MANAGER, requesting a quote
     for desired zip codes and types of businesses.  After a deposit,
     the completed file can then be mailed to you on a floppy, or made
     available to you on the Bulletin Board.


     B&B DOALL User's Guide                                         43

     LABELING Machines
     -----------------
     Machines are available to affix self adhesive labels onto your
     mailing pieces.  Some manufacturers:Novatec of Gladwyne, PA;
     Master Addresser of Minneapolis, MN.

     TEXT EDITING - CUT & PASTE
     --------------------------
     In some B&B systems you will be given the opportunity to edit a
     file such as a report or letter prior to printing.  You can do
     some simple cut and pasting using FoxPro commands.  To 'block' or
     highlight text, use SHIFT and the ARROW KEYS. After highlighting,
     you can cut text with Ctrl-X, to copy the text, use Ctrl-C and to
     Paste the text you've highlighted, use Ctrl-V.

     Other Key Combinations
     ======================
     TAB - moves field by field to the right in Browse screens.
     SHIFT-TAB - moves field by field to the left.
     CTRL-W - will save editing screens
     CTRL-Q - will not save editing screens
     CTRL-Right Arrow - move one word to the right
     CTRL-Left Arrow - move one word to the left

































     B&B DOALL User's Guide                                         44

     ERRORS -
     TROUBLESHOOTING
     ---------------
     Before calling for technical support, many problems can be
     resolved by: 1. Ensuring that you have all of the files listed in
     this documentation.  2. Checking your config.sys file for the
     proper Buffers and Files statements.

     ERROR: Cannot create program file - system does not load
     FIX:   Check CONFIG.FP file carefully.  It probably contains a
     directory that does not exist.

     Q. My data appears unordered.  When I select the LASTNAME sort,
     the records are not sorted by lastname.
     A. The sorts are all stored in a multiple index file called
     <filename>.CDX.  This file is created upon startup if it is
     missing.  If you accessed your data file without the .CDX being
     active, or somehow had corruption on your disk, the .CDX will not
     point to the right records.  Just ERASE the <filename>.CDX file
     and a new one will be created.

     Q. WHEN I EDIT MY PRINT CODES FILE, I WANT TO DIRECT MY PRINTED
     OUTPUT TO A QUEUE or SERVER NAME, HOW DO I DO IT?
     A. In the field that defines the printer port, use:
     \S=<servername> or \Q=<queue> with no quotation marks around the
     queue or server name.

     Q. WHEN PRINTING MY REPORTS, THE DATA APPEARS TO CONTAIN
     DUPLICATES OF ONE RECORD.
     A. Check your report file (.FRX) to make sure that the individual
     fields do not contain a file alias for each field, such as
     myfile.lastname.  Eliminate alias, or file names, from any field
     names.























     B&B DOALL User's Guide                                         45

     HELP.  I'M STUCK
     ----------------
     ANY PROGRAM CAN CORRUPT FILES - HOW TO AVOID IT
     -----------------------------------------------
     If you are running a system and you get into a situation that
     you'd like to exit from, some applications allow you to enter the
     <ESC> key.  In other systems. you may need to wait for the
     process to end.  If your system allows the use of the ESC key,
     and B&B does, use it, the ESC key will not alter or change the
     files.  BUT, Be patient.  Depending on what the system was doing,
     it may take 1 second or 1 minute.   BUT PLEASE, IN ALMOST ALL
     CASES, AVOID RE-BOOTING (cold or warm boots).  If you re-boot
     your computer BEFORE your system finishes the process it is
     currently working on, you could corrupt your file(s).  The
     computer may have been READING data, but does not now know where
     to WRITE it.  THIS IS ONE OF THE MAJOR CAUSES OF CORRUPTED FILES.
     This is another good reason for frequent back-ups.

     If you are not sure if your file has become corrupted, print a
     report that lists the entire file.  If any of the data appears
     missing or switched, your file is probably corrupted.  If binary,
     or strange looking characters appear, your file is corrupted.  If
     you're not sure, first make a new index file by erasing the .CDX
     file (a new .CDX file will be created, with a sort definition for
     EACH field in the data file).  Re-run your report, and if that
     does not fix the 'order' of your data, AND IF YOU ARE NOT IN A
     NETWORK, run the DOS CHKDSK program with the '/f' (fix lost
     clusters option), C:DOS>CHKDSK C:/f.   If corruption did occur,
     DOS will write the corrupted data in separate files called
     FILE0001.CHK, 0002, etc.  Since this data has now been separated
     from your .dbf or other files, you should copy your .dbf files
     from your backup. If your B&B System does not boot properly, you
     may need to copy your system files from back-up also.


     HINT: CHKDSK is a good command to insert in your autoexec.bat
     file,  so that your hard drive is checked every time you turn
     your computer on.  This takes 10 to 20 seconds longer to boot,
     but it will avoid the continued corruption of a fragmented disk.
     DO NOT RUN CHKDSK ON A NOVELL NETWARE FORMATTED disk, but you can
     run CHKDSK prior to loading LAN software on a peer-to-peer type
     network drive.


     DEVELOPERS/CONSULTANTS
     ======================
     Because B&B Doall allows flexibility in accessing any type of
     .dbf file, developers can customize systems for their users
     through the use of the custom.prg program and by using the setup
     parameters.  This reduces your development time and gives
     customers faster/economical service.


     FILES
     =====
     FOXPRO.ESO, .ESL, and FOXR are the FoxPro2 runtime files
     B&B DOALL User's Guide                                         46

     (FOXPROX.ESL is available for higher performance machines (386 or
     above) with Expanded Memory, giving greater performance. Need to
     get Expanded versions of other .FXP files too on B&B's BBS).

     DOALL.FXP or .EXE, P.FXP and PDRIVER.FXP are your B&B DOALL
     System files.

     P_CODES.DBF, .CDX are the files containing printer control codes

     <DataBaseName>.CDX is the file containing all of your sorting
     information.  And, starting with version 1.5, if you define a new
     sort, it will not have to be re-created each time you want to use
     it.  All custom sorts added to Flexi-Sort are maintained
     continuously when you add and delete records.

     CONFIG.FP is FoxPro's configuration file.  If you have a Foxpro
     manual, refer to it for customization features.

     CUSTOM.PRG - Sample file that is executed whenever DOALL is
     started.  You can use Xbase code to write any startup program
     you'd like, then compile it with FoxPro to make an .FXP file.

     PRODUCT.DBF - Sample data base file that can be filled with
     product information for instant access.  It is called by using
     <CTRL-F2> as defined in the coding in custom.prg.

     HELPFILE.DBF - Sample help file customizable by user.
     .CDX files - Index or Sort file created by DOALL.  Initially,
     there is one index for each field in the data file.  Newly
     defined sorts are added to this file.
     .LBX/.LBT - sample Label format files.
     .FRX/.FRT - sample Report format files.
     ZIP.DBF - sample zip file accessed as a lookup file <F2> when in
     the zip code field.
     STATE.DBF - see zip.dbf
     REP.DBF - use for a code for Sales Reps or Local Offices.
     DISTRIBU.DBF - use for a code for Distributors.


     Environmental Variables:
     SET ASCEDESC=ASCENDING or DESCENDING, Depending on default index
     order desired.

     SAMPLES of filenames (for a data file called "SAMP"LE.DBF):
     -----------------------------------------------------------
     SAMP SORT.MEM - Flexi-Sort definitions
     SAMP SELE.MEM - Flexi-Select definitions.
     SAMP RPT.MEM - Flexi-Report definitions.
     SAMP SPC.MEM - Field Name/Index used when Adding-Duplicate check.
     SAMP QLBL.MEM - Set up values for Quick Label
     SAMP EXIM.MEM - Import/Export definitions
     SAMP FIND.MEM - Default Field used in Find/Replace in Browse
     SAMP ZRPT.MEM - Print Setup values for zip code group report.
     SAMP FREP.MEM - Print Setup values for Flexi-Report.
     SAMP SETP.MEM - Print Setup values when sending setup codes.
     SAMP REPO.MEM - Print Setup values for FoxPro Reports.
     B&B DOALL User's Guide                                         47

     SAMP LABE.MEM - Print Setup values for Labels.
     SAMP LTRS.MEM - Print Setup values for Letters.
     SAMP SREP.MEM - contains Field defined as Rep Code for sending
     uploads to central office
     SAMP GREP.MEM - contains Field defined as Rep Code and last
     directory location for getting downloads from central office.

     SAMPLE.DBF/.FPT - Name of Sample.dbf and memo file
     SAMPLE.FXP - Name of Sample.prg after compilation
     SAMPLE.LBX/.LBT - Label form file and memo file
     SAMPLE.FRX/.FRT - Report form file and memo file













































     B&B DOALL User's Guide                                         48

     --------
     UPGRADES
     --------
     The most recent demo versions of B&B Systems programs are on
     Compuserve (GO IBMAPP), EXECPC, or B&B's own Bulletin Board, PC
     MANAGER, [phone].  [Settings:8/N/1, 8 data bits, No
     Parity,1 Stop bit].  B&B's Bulletin Board supplies registered
     owners with the latest versions of unrestricted B&B Systems
     without waiting for mailed copies.

     Occasionally, new upgraded files like printer codes or letter
     files become available.  They normally have "UPGR" incorporated
     into the file name, and can be copied onto the regular directory.
     When your system is started, you will be asked if you want to
     upgrade this new file.



     --------------------
     ORDERING INFORMATION
     --------------------
     If ordering by check, please allow at least 2 weeks.  If you
     prefer, B&B Systems can supply your program via modem provided
     you register on our bulletin board.  This has two advantages:
     1. upgrades of new unlimited versions become available
     immediately. 2. If paying by Visa/Master Charge, you can get your
     system faster, as soon as 1/2 hour.

               Note: If your system is licensed on an annual
               basis, and you wish an upgrade, all you need
               to do is:
               1. Contact B&B systems. Find out if we have
               an upgrade that interests you (Technical
               support subscribers receive upgrade
               notification automatically).
               2. If you wish the free upgrade, we will put
               a special file on the Bulletin Board System
               for you to download via modem at your leisure
               (Commonly using your company name for the
               filename).  If you cannot download your
               upgrade and require us to send a disk, there
               is a $25 handling fee.

     If you desire that certain features be included in newer
     versions, contact us to see if the enhancements have already been
     included in new versions, or if your special needs can be
     incorporated into future versions.

     You can order by calling B&B Systems direct (414-544-5988), or
     call our Bulletin Board, P.C. Manager (414-548-9034) and <A>CCESS
     the ORDER system from the Main Menu.  You will be asked for
     shipping information and your credit card data.  After your card
     is verified, you will be authorized to download registered
     versions, usually .zip or .exe files that end in .ziu or .exu
     (unlimited).

     B&B DOALL User's Guide                                         49

     If you order by mail, and plan to download electronically, you
     will be registered under the first and last name and password you
     supply on the order form in this file.  It is recommended that
     you change your password after accessing B&B System's bulletin
     board the first time.

     If you ordered from a dealer and want to be eligible for
     upgrades, sign on to P.C. Manager, and leave a message that you
     would like a security level allowing upgrade downloads, and which
     dealer you purchased your system from.  Once the purchase has
     been validated, your security level will be upgraded.

     We try to keep our software costs low.  Our policies are simple.
     1. Since no software is error-free, we will fix any bugs.  2. We
     will add improvements requested by users, and do it free if it
     has value to other users.  3. We cannot afford to train users how
     to run computers, use DOS commands, or even how to run their B&B
     Systems unless they register for annual technical support
     services.

     If you've forgotten to register a DEMO and need to access your
     system immediately, we can sometimes supply an emergency access
     code over the phone with a credit card order.

     If you plan on installing B&B systems on MORE than one machine,
     consider a SITE LICENSE.  You can move a registered system to a
     different machine, but making copies is not only illegal, but
     more importantly, unethical.  A SITE LICENSE allows unlimited use
     of NETWORK or STAND-ALONE versions at one location.  A CORPORATE
     LICENSE allows the same unlimited use, but at multiple locations.
     LICENSES are not software purchases.  They are licenses to use
     software for a specific period of time, normally annually.

     OTHER SERVICES: (billable by project or by hour)
     CREATE NEW or MODIFY EXISTING B&B SYSTEMS add/edit screens, rpts.
     REMOTE LASER LETTER/REPORT PRINTING programs
     OPERATE WARRANTY/SALES LEAD CARD FULFILLMENT programs
     FILE CONVERSION/CORRUPTION (upload to BBS, download Fixed file)


















     B&B DOALL User's Guide                                         50

                              -------------------
                              O R D E R   F O R M
                              -------------------
                             B & B   S Y S T E M S
                          627 Madison   P.O. Box 171
                          Waukesha, Wisconsin  53187
         Order/Technical Support: 414-544-5988   BBS: 414-548-9034

              DESCRIPTION                QUANTITY     EACH    TOTAL
         -------------------------------------------------------------
         B&B DOALL System       License     _____    250.00    _______
                                SITE LIC    _____    500.00    _______
                                CORP LIC    _____   1200.00    _______

         Upgrades (50% of price above)                         _______
         ONE YEAR's UNLIMITED Technical Support Phone service
         (Annual $ amount same as software cost above)        $_______

         FILE CONVERSION SERVICE (# records)=_____ x $.10     $_______

         Customization Service (screens, etc. - call)         $_______

         Shipping and Handling:
           ___ Sign me up on BBS for immediate downloading - $0
               Password desired ____________
           ___ US Postal Service - $0
           ___ Express Mail $12                               $_______
                                            WI 5% Sales Tax   $_______
           Format:___ 5-1/4"  ___ 3-1/2"             Total:   $_______


        Visa/MC Card Number:  _____________________ Exp Date:________

        Signature: __________________________________________________

        Name:   _____________________________________________________

        Street Address: _____________________________________________
                             (if PO Box, add street address)

        City:   ______________________  State: _____  Zip: __________

        Bus. Phone: (      ) __________________________
        Current Version # _______________      Date:_________________












     B&B DOALL User's Guide                                         51

     WARRANTY
     --------
     DISCLAIMER OF WARRANTY AND LIMITED WARRANTY
     The Software and accompanying written materials (including
     instructions for use) are provided 'As Is'  without warranty of
     any kind. Further, B&B Systems does not warrant, guarantee, or
     make any representations regarding the use, or the results of the
     use, of the Software or written materials in terms of
     correctness, accuracy, reliability, currentness, or otherwise.
     The entire risk as to the results and performance of the Software
     is assumed by you.  If the Software or written materials are
     defective, you, and not B&B Systems or its dealers, distributors,
     agents, or employees, assume the entire cost of all necessary
     servicing, repair, or correction.

     B&B Systems warrants to the original LICENSEE that 1) the disks
     on which the SOFTWARE is recorded is free from defects in
     materials and workmanship under normal use and service for a
     period of ninety (90) days from the date of delivery as evidenced
     by a copy of the receipt.  Further, B&B Systems hereby limits the
     duration of any implied warranty(ies) on the disk to the
     respective period stated above.  Some states do not allow
     limitations on duration of an implied warranty, so the above
     limitation may not apply to you.

     B&B Systems' entire liability and your exclusive remedy as to the
     disk(s) shall be, at B&B Systems ' option, either a) return of
     the purchase price or b) replacement of the disk(s) that does not
     meet B&B Systems' Limited Warranty and which is returned to B&B
     Systems with a copy of the receipt.  If failure of the disk(s)
     has resulted from accident, abuse, or misapplication, B&B Systems
     shall have no responsibility to replace the disk(s), or refund
     the purchase price.  Any replacement disk(s) will be warranted
     for the remainder of the original warranty period, or thirty (30)
     days, whichever is longer.

     THE ABOVE ARE THE ONLY WARRANTIES OF ANY KIND, EITHER EXPRESSED
     OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE IMPLIED WARRANTIES
     OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE, THAT ARE
     MADE BY B&B Systems ON THIS B&B Systems PRODUCT. NO WRITTEN OR
     ORAL INFORMATION OR ADVICE GIVEN BY B&B Systems, ITS DEALERS,
     DISTRIBUTORS, AGENTS, OR EMPLOYEES SHALL CREATE A WARRANTY OR IN
     ANY WAY INCREASE THE SCOPE OF THIS WARRANTY, AND YOU MAY NOT RELY
     ON ANY SUCH INFORMATION OR ADVICE. THIS WARRANTY GIVES YOU
     SPECIFIC LEGAL RIGHTS.  YOU MAY HAVE OTHER RIGHTS, WHICH VARY
     FROM STATE TO STATE.

     NEITHER B&B Systems NOR ANYONE ELSE WHO HAS BEEN INVOLVED IN THE
     CREATION, PRODUCTION, OR DELIVERY OF THIS PRODUCT SHALL BE LIABLE
     FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL OR INCIDENTAL DAMAGES
     (INCLUDING DAMAGES FOR LOSS OF BUSINESS PROFITS, BUSINESS
     INTERRUPTION, LOSS OF BUSINESS INFORMATION, AND THE LIKE) ARISING
     OUT OF THE USE OF OR INABILITY TO USE SUCH PRODUCT EVEN IF B&B
     Systems HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.
     BECAUSE SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF
     LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES , THE ABOVE
     B&B DOALL User's Guide                                         52

     LIMITATION MAY NOT APPLY TO YOU.

     The SOFTWARE and documentation is provided with RESTRICTED
     RIGHTS.  Use, duplication, or disclosure is subject to
     restrictions as set forth in subdivision (b)(3)(ii) of the Rights
     in Technical Data and Computer Software clause at 252.227-7013.
     Contractor/Manufacturer is B&B Systems, P.O.Box 171, Waukesha,
     Wisconsin 53187.
















































     B&B DOALL User's Guide                                         53

     INDEX

     .FRX 17, 18, 44, 46
     .PRX 16
     ACCURACY 29, 51
     ACTDATE1 3, 25, 26
     ACTION1 3, 25, 26
     ADD 1-3, 7-11, 13-21, 23-25, 28, 29, 31, 32, 34-36, 38-40,
                                                            46, 49, 50
     ADD SCREEN 8, 14-16, 38
     ADDLTR 19-22
     ALIAS 18, 44
     ALLCODES 20
     ASCII 14, 17, 31-33, 42
     AUTOEXEC.BAT 5, 45
     BACKUP 4, 9, 11, 12, 42, 45
     BARCODE 27
     BELLRINGER 3, 19
     CALLBACK , 2, , 28,
     CANADA 14
     CENTRAL OFFICE 3, 33, 34, 47
     CNG 8
     COLOR 2, 7, 8, 37
     COLORDEF.DBF 37
     CONFIG.FP 5-7, 9, 44, 46
     CONFIG.SYS 6, 8, 44
     CONVERSION 42, 49, 50
     CONVERT 37, 42
     CUSTOMIZATION 12, 16, 17, 46, 50
     CUT & PASTE 43
     Data appears unordered
          SORT 44
     DEFAULT 6, 9, 13, 14, 27, 29, 31, 36, 37, 46
     DOS ENVIRONMENTAL VARIABLES 5
     DUPLICATE 14, 18, 29, 34, 37, 46
     EDIT SCREEN 16
     ENVIRONMENTAL 4, 5, 46
     ERROR 4, 5, 7, 44, 49
     ERRORS 4, 44
     F10 15, 16
     F2 LOOKUP 6
     FILELOOK 14, 15
     FLEXI-REPORT 46
     FLEXI-SELECT 10, 11, 16, 25, 26, 28, 29, 31, 35, , 41, 46
     FLEXI-SORT 9, 11, 31, 46
     FOXUSER.DBF 5
     FOXUSER.FPT 5
     FUNCTION 2, 11, 13, 14, 19, 34
     HELP 2, 4, 9, , 45,
     HELPFILE
     IMPORT/EXPORT 13, 14, 31, 33, 46
     INSTALLATION 4, 5, 27
     KEY COMBINATIONS 43
     LABELS 2, , 2, 10, 17, 18, 26, 27, 42, 43, 47
     LETTERS 2, , 2, 3, 18-27, 32, 38, 39, 42, 47
     LOOKUP 2, 6, 12-15, 20, 31, 46
     B&B DOALL User's Guide                                         54

     MAINTENANCE 15, 23, 34, 35, 37, 40
     MINIMUM MEMORY
          Memory, Minimum 6
     MODEM 7, 14, 27, 28, 48
     NETWORK 4-8, 34, 45, 49
     OPERATING 6, 7, 17, 20
     PHONE 2, 20, 27, 28, , 29, 33-35, 38, 40, 49, 50
     POSTSCRIPT 36
     PRINTER CONTROL 39, 46
     QUERY 2, 18
     QUERY BY EXAMPLE 2
     RECALL 29
     REP 15, 18, 20-25, 33, 34, 38, 46, 47
     REPORTS 2, 3, 10, 17, 18, 22-25, 27, 44, 46
     RUNTIME FILES 2, 7, 8, 45
     SALES REPS 3, 20-22, 25, 34, 46
     SAMPLE 9, 16, 17, 19-23, 27, 29, 46, , 46, 47
     SETUP 4, 5, 14, 15, , 18, 23, 28, 36, 37, 45, 46
     SITE 49, 50
     SPECIAL HANDLING 19, 39
     SPEED TIP 11
     SQL 2, , 8, 17, 18, 33
     STORAGE 6
     STRUCTURE 15, 31, 35, 42
     TAX 50
     TIP 4, 7, 8, 11, 12, 14, 29, 31, 35, 36, 38, 39
     TOPIC 2, 28
     UTILITY 33
     VEHICLE FILE 4
     VOLUME 39
     WARRANTY 49, 51
     WHAT IF I HAVE FOXPRO 18
     WINDOWS 4, 7, 8, 17